Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
stats_concepts [2017/03/20 11:47]
steveclarke [Reliability]
stats_concepts [2018/04/10 09:12] (current)
72.38.112.148
Line 73: Line 73:
 Steps for calculating Adverse Impact. Steps for calculating Adverse Impact.
  
-1. At each score, calculate the pass rate percentage for each subgroup. (divide the number of persons in each group (ethnicity subgroups and gender subgroups - that had that score by the total number of people in that subgroup) +  - At each score, calculate the pass rate percentage for each subgroup. (divide the number of persons in each group (ethnicity subgroups and gender subgroups - that had that score by the total number of people in that subgroup) 
-2. Identify the highest percentage +  ​- ​Identify the highest percentage 
-3. Divide each of the other percentages by the higher percentage – if it is less than 80% than that group is adversely impacted. ​+  ​- ​Divide each of the other percentages by the higher percentage – if it is less than 80% than that group is adversely impacted. ​
  
  
Line 82: Line 82:
 If you were to pretend that those were the only three groups – the 1.1% would be the highest percentage rate.  If you were to pretend that those were the only three groups – the 1.1% would be the highest percentage rate. 
  
-1. If the passpoint were set at a score of 69.8, 0 Caucasian candidates out 16 Caucasian passed = 0%; 1/92 Black passed = 1.1%; 1/111 Hispanic passed = 0.9% passed. ​ (pretending those are the only 3 groups for demonstrative purposes) +  - If the passpoint were set at a score of 69.8, 0 Caucasian candidates out 16 Caucasian passed = 0%; 1/92 Black passed = 1.1%; 1/111 Hispanic passed = 0.9% passed. ​ (pretending those are the only 3 groups for demonstrative purposes) 
-2. The highest is 1.1% for Blacks +  ​- ​The highest is 1.1% for Blacks 
-3. Calculate the pass rates: +  ​- ​Calculate the pass rates: 
-a. Caucasian 0/1.1 = 0% - less than 80% so there is Adverse Impact (thus the * next to it) +    ​* ​Caucasian 0/1.1 = 0% - less than 80% so there is Adverse Impact (thus the * next to it) 
-b. Hispanic 0.9/1.1 = 81.8% - more than 80% so there is no Adverse impact (therefore no * next to it) +    ​* ​Hispanic 0.9/1.1 = 81.8% - more than 80% so there is no Adverse impact (therefore no * next to it)
  
 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|}}
  
 ==== Alternate Scores ==== ==== Alternate Scores ====
Line 113: 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 171: 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|}}|