2. (30 points) Using the TERM worksheet calculate the rate of selection for each group below (i.e., TERM females / ACTIVE females). Using these rates calculate adverse impact for each of these groups. For negative transactions, i.e. terminations, the lowest rate (most favored) for the group is placed in the numerator position. Show your calculations. Indicate whether Adverse Impact is present (Yes or No). NOTE: If any of the comparison groups do not have a passing rate equal to or greater than 80% of the passing rate of the highest group, then it is generally held that evidence of adverse impact exists for the particular selection procedure. Refer to article "Avoiding Adverse Impact in Employment Practices" for background, definitions, and calculations. a. Sex (males, females) b. Minority vs Non-Minority c. Under 40 vs 40 and Over

72173 FINANCIAL SERVICE ADVISOR 403 M 20 White Term 38034 RETENTION ADVISOR 403 F 20 Hispanic Term 72179 CUSTOMER RELATIONSHIP SPEC 402 F 21 White Term 72174 CUSTOMER RELATIONSHIP SPEC 402 F 21 White Term 72179 FINANCIAL SERVICE ADVISOR 403 M 21 White Term 72173 FINANCIAL SERVICE ADVISOR 403 M 22 White Term 72173 FINANCIAL SERVICE ADVISOR 403 F 22 White Term 15429 FINANCIAL SERVICE ADVISOR 403 F 23 Hispanic Term 72173 FINANCIAL SERVICE ADVISOR 403 M 23 White Term 38034 RETENTION ADVISOR 403 F 24 Hispanic Term 72179 FINANCIAL SERVICE ADVISOR 403 F 24 White Term 15429 FINANCIAL SERVICE ADVISOR 403 F 24 Hispanic Term 72173 FINANCIAL SERVICE ADVISOR 403 F 24 White Term 72173 FINANCIAL SERVICE ADVISOR 403 F 25 Black Term 15856 COLLECTOR III 403 F 25 Hispanic Term 72173 FINANCIAL SERVICE ADVISOR 403 M 25 Hispanic Term 15429 FINANCIAL SERVICE ADVISOR SR 403 F 25 White Term 72173 FINANCIAL SERVICE ADVISOR 403 F 25 White Term 15856 FINANCIAL SERVICE ADVISOR 403 F 25 White Term 72173 FINANCIAL SERVICE ADVISOR 403 F 25 White Term 15856 CUSTOMER SERVICE REP II 402 F 26 Hispanic Term 72173 FINANCIAL SERVICE ADVISOR 403 M 26 White Term 72179 CALL CENTER COORDINATOR 403 F 26 Black Term 72173 FINANCIAL SERVICE ADVISOR 403 F 27 White Term 15856 SUPPORT CLERK II 402 F 27 Hispanic Term 15429 FINANCIAL SERVICE ADVISOR SR 403 M 27 Black Term 72173 FINANCIAL SERVICE ADVISOR 403 F 27 White Term 15856 SUPPORT CLERK II 402 F 27 Hispanic Term 57932 FINANCIAL SERVICE ADVISOR SR 403 F 27 Hispanic Term 15429 FINANCIAL SERVICE ADVISOR 403 F 27 Hispanic Term 57932 FINANCIAL SERVICE ADVISOR SR 403 F 27 Hispanic Term 72179 FINANCIAL SERVICE ADVISOR 403 M 28 Hispanic Term 72173 FINANCIAL SERVICE ADVISOR 403 M 29 White Term 15429 FINANCIAL SERVICE ADVISOR 403 F 29 Hispanic Term 15856 FINANCIAL SERVICE ADVISOR 403 F 29 Hispanic Term 57932 FINANCIAL SERVICE ADVISOR SR 403 F 29 White Term 15856 FINANCIAL SERVICE ADVISOR 403 M 29 White Term 72179 FINANCIAL SERVICE ADVISOR 403 F 30 White Term 72173 FINANCIAL SERVICE ADVISOR 403 M 30 White Term 72179 CALL CENTER COORDINATOR 403 F 31 White Term 72173 FINANCIAL SERVICE ADVISOR 403 M 31 White Term 38034 RETENTION ADVISOR 403 F 31 Hispanic Term 72173 FINANCIAL SERVICE ADVISOR 403 F 31 White Term 72179 FINANCIAL SERVICE ADVISOR 403 M 32 White Term 72174 FINANCIAL SERVICE ADVISOR 403 F 32 White Term 72174 FINANCIAL SERVICE ADVISOR 403 F 32 Black Term 72173 CALL CENTER COORDINATOR 403 F 32 White Term 72179 SUPPORT CLERK I 401 F 32 Hispanic Term 72179 FINANCIAL SERVICE ADVISOR 403 F 32 White Term 72174 ADMINISTRATIVE ASSISTANT 403 F 33 White Term 72174 FINANCIAL SERVICE ADVISOR 403 F 33 White Term 15856 FINANCIAL SERVICE ADVISOR 403 F 33 White Term 15429 CUSTOMER SERVICE REP II 402 M 33 Hispanic Term 15856 CUSTOMER SERVICE REP II 402 F 34 Hispanic Term 72173 FINANCIAL SERVICE ADVISOR 403 F 34 White Term 72173 FINANCIAL SERVICE ADVISOR 403 F 35 White Term 15429 FINANCIAL SERVICE ADVISOR 403 F 35 Hispanic Term 15429 CUSTOMER SUPPORT REP III 403 F 35 Black Term 15856 FINANCIAL SERVICE ADVISOR 403 F 35 White Term 15429 CUSTOMER SUPPORT REP II 402 M 35 White Term 72179 FINANCIAL SERVICE ADVISOR 403 M 36 White Term 15856 FINANCIAL SERVICE ADVISOR 403 F 36 Hispanic Term 72173 FINANCIAL SERVICE ADVISOR 403 F 40 White Term 38034 FINANCIAL SERVICE ADVISOR SR 403 M 40 Hispanic Term 15429 CUSTOMER SERVICE REP II 402 F 40 Black Term 72173 CALL CENTER COORDINATOR 403 M 41 White Term 38034 RETENTION ADVISOR 403 F 43 Hispanic Term 72179 FINANCIAL SERVICE ADVISOR SR 403 F 44 White Term 15856 FINANCIAL SERVICE ADVISOR 403 F 44 Hispanic Term 15856 FINANCIAL SERVICE ADVISOR 403 M 44 Black Term 72179 ADMINISTRATIVE ASSISTANT 403 F 44 White Term 15429 FINANCIAL SERVICE ADVISOR 403 F 45 White Term 72179 CALL CENTER COORDINATOR 403 F 45 White Term 15429 CUSTOMER SERVICE REP II 402 F 45 White Term 38034 SUPPORT CLERK I 401 F 45 Hispanic Term 72173 FINANCIAL SERVICE ADVISOR 403 F 47 White Term 15856 FINANCIAL SERVICE ADVISOR 403 F 49 Hispanic Term 72179 FINANCIAL SERVICE ADVISOR 403 F 50 White Term 72173 FINANCIAL SERVICE ADVISOR 403 M 50 White Term 15856 FINANCIAL SERVICE ADVISOR 403 F 50 Hispanic Term 15856 CUSTOMER SERVICE REP II 402 F 51 White Term 15429 FINANCIAL SERVICE ADVISOR SR 403 M 51 White Term 72173 CALL CENTER COORDINATOR 403 M 51 White Term 72173 FINANCIAL SERVICE ADVISOR 403 F 52 White Term 72179 FINANCIAL SERVICE ADVISOR 403 F 53 White Term 72174 FINANCIAL SERVICE ADVISOR 403 F 54 White Term 15856 SUPPORT CLERK II 402 F 55 Hispanic Term 15429 FINANCIAL SERVICE ADVISOR 403 F 57 White Term 57932 FINANCIAL SERVICE ADVISOR SR 403 F 59 White Term 72179 FINANCIAL SERVICE ADVISOR 403 F 60 White Term 72174 FINANCIAL SERVICE ADVISOR 403 M 61 White Term 38034 RETENTION ADVISOR 403 F 63 White Term 72167 SUPPORT CLERK I 401 F 72 White Term

(30 points) Using the TERM worksheet calculate the rate of selection for each group below (i.e., TERM females / ACTIVE females). Using these rates calculate adverse impact for each of these groups. For negative transactions, i.e. terminations, the lowest rate (most favored) for the group is placed in the numerator position. Show your calculations. Indicate whether Adverse Impact is present (Yes or No). NOTE: If any of the comparison groups do not have a passing rate equal to or greater than 80% of the passing rate of the highest group, then it is generally held that evidence of adverse impact exists for the particular selection procedure. Refer to article "Avoiding Adverse Impact in Employment Practices" for background, definitions, and calculations.

a. Sex (males, females)

b. Minority vs Non-Minority

c. Under 40 vs 40 and Over

%= numerator