passing Point = | 80 | ||||||||
Male passing Count = | 7 | ||||||||
Female Passing Count = | 5 | ||||||||
Male Total Count = | 9 | ||||||||
Female Total Count = | 26 | ||||||||
Male Passing % = 7/9 = | 78% | ||||||||
Female Passing % = 5/26 = | 19% | ||||||||
Adverse Impact Ratio for Female = 19%/78% = | 24.73% | ||||||||
Adverse Impact Ratio is less than 80%, hence by according to the four-fifths rule Adverse impact is Present |
Paste Font Alignment Number fc AVERAGE(A2:A6) A8 1 MALE FEMALE 123.4 132.8 68.8 121.8 73.8 33.1 53.1 78.1 55.5 81.2 4 104.12 MALE 83 120 98 116 76 70 98 FEMALE 85 65 69 61 62 81 81 60 70 87 82...