Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
stats_concepts [2017/03/20 11:52] steveclarke [Adverse Impact] |
stats_concepts [2018/04/10 09:12] (current) 72.38.112.148 |
||
|---|---|---|---|
| Line 89: | Line 89: | ||
| A second example: | A second example: | ||
| - | 1. For the score of 66.1 – 3/16 Caucasian passed = 18.75%; 6 out 92 Black passed = 6.52%; 5 out of 111 Hispanic passed = 4.50% | + | - For the score of 66.1 – 3/16 Caucasian passed = 18.75%; 6 out 92 Black passed = 6.52%; 5 out of 111 Hispanic passed = 4.50% |
| - | 2. Highest percentage is 18.75% for Caucasian | + | - Highest percentage is 18.75% for Caucasian |
| - | 3. Calculate the pass rates | + | - Calculate the pass rates |
| - | a. Black = 6.52/18.75 = 34.8% - Less than 80%, so there is Adverse Impact | + | * Black = 6.52/18.75 = 34.8% - Less than 80%, so there is Adverse Impact |
| - | b. Hispanci = 4.5/18.75 = 24% - less than 80%, so there is Adverse Impact | + | * Hispanic = 4.5/18.75 = 24% - less than 80%, so there is Adverse Impact |
| - | + | ||
| - | These files are calculating this for every single score. | + | |
| {{:adverseimpact.png?600|}} | {{:adverseimpact.png?600|}} | ||
| Line 114: | Line 112: | ||
| We have the following systems loaded with values: | We have the following systems loaded with values: | ||
| ^System^AlternateBase^AlternateMean^AlternateStDev^ | ^System^AlternateBase^AlternateMean^AlternateStDev^ | ||
| - | |rue (Default)|?|-|-| | + | |True (Default)|?|-|-| |
| |Custom|?|0 or Calculated|0 or Calculated| | |Custom|?|0 or Calculated|0 or Calculated| | ||
| |Z Scores|?|0|1| | |Z Scores|?|0|1| | ||
| Line 172: | Line 170: | ||
| |d|{{:stat_biserialcorrected_d.png?|}} \\ **ABS** function returns the **absolute value** (i.e. the modulus) of any supplied number. The syntax of the function is: ABS(number). where the number argument is the numeric value that you want the modulus of.| | |d|{{:stat_biserialcorrected_d.png?|}} \\ **ABS** function returns the **absolute value** (i.e. the modulus) of any supplied number. The syntax of the function is: ABS(number). where the number argument is the numeric value that you want the modulus of.| | ||
| |Ordinal|{{:stat_biserialcorrected_d.png?|}} \\ **EXP** function in Excel **calculates** for the value of “e” raise to certain power of **integer**. “e” is a constant number which is equal to 2.71828182845904, the **natural logarithm** base. When it comes to the value of e, Excel uses a value of 2.718282.| | |Ordinal|{{:stat_biserialcorrected_d.png?|}} \\ **EXP** function in Excel **calculates** for the value of “e” raise to certain power of **integer**. “e” is a constant number which is equal to 2.71828182845904, the **natural logarithm** base. When it comes to the value of e, Excel uses a value of 2.718282.| | ||
| - | ||{{:stat_biserialcorrected.png?|}}| | + | ||{{:stat_biserialcorrected.png?200|}}| |
