3. (30 points) Using the PROMO worksheet calculate the rate of selection for each group below (i.e., PROMO females / ACTIVE females). Using these rates, calculate adverse impact for each of these groups. The highest rate (most favored) for the group is placed in the denominator 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. Age (under 40; 40 and over)

15429 FINANCIAL SERVICE ADVISOR 403 M 18 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 19 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 M 20 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 20 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 21 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 21 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 M 21 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 21 Hispanic Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 22 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 22 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 22 White Active Y 72167 FINANCIAL SERVICE ADVISOR 403 M 22 White Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 23 Hispanic Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 23 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 23 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 M 23 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 23 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 24 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 M 24 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 24 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 24 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 M 24 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 24 Hispanic Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 24 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 25 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 25 Hispanic Active Y 15429 FINANCIAL SERVICE ADVISOR 403 M 25 Hispanic Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 25 Hispanic Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 25 Hispanic Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 25 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 25 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 26 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 26 Hispanic Active Y 57932 FINANCIAL SERVICE ADVISOR 403 M 26 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 26 White Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 26 Hispanic Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 26 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 27 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 M 27 Black Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 27 Hispanic Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 27 White Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 27 Hispanic Active Y 15429 FINANCIAL SERVICE ADVISOR 403 M 28 Hispanic Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 28 Hispanic Active Y 72179 FINANCIAL SERVICE ADVISOR 403 M 28 White Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 28 Hispanic Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 28 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 29 White Active Y 72167 FINANCIAL SERVICE ADVISOR 403 M 29 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 29 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 29 White Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 30 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 30 Hispanic Active Y 15429 FINANCIAL SERVICE ADVISOR 403 M 30 White Active Y 15856 FINANCIAL SERVICE ADVISOR 403 M 30 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 31 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 31 White Active Y 57932 FINANCIAL SERVICE ADVISOR 403 F 31 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 31 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 32 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 M 32 Black Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 32 White Active Y 72167 FINANCIAL SERVICE ADVISOR 403 F 32 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 33 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 33 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 34 White Active Y 72167 FINANCIAL SERVICE ADVISOR 403 M 34 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 M 34 Black Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 35 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 M 35 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 35 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 36 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 36 Hispanic Active Y 15856 FINANCIAL SERVICE ADVISOR 403 M 37 Hispanic Active Y 72167 FINANCIAL SERVICE ADVISOR 403 F 37 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 38 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 38 Hispanic Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 39 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 39 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 40 Asian/Pacific Islander Active Y 72167 FINANCIAL SERVICE ADVISOR 403 M 41 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 41 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 41 White Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 42 Hispanic Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 43 Hispanic Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 43 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 44 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 44 White Active Y 15856 FINANCIAL SERVICE ADVISOR 403 M 44 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 M 45 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 45 Black Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 46 White Active Y 72167 FINANCIAL SERVICE ADVISOR 403 F 46 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 47 Hispanic Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 47 Hispanic Active Y 72174 FINANCIAL SERVICE ADVISOR 403 F 48 White Active Y 72174 FINANCIAL SERVICE ADVISOR 403 F 48 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 49 Black Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 50 White Active Y 57932 FINANCIAL SERVICE ADVISOR 403 M 50 Black Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 51 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 51 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 52 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 53 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 54 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 M 55 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 56 White Active Y 15856 FINANCIAL SERVICE ADVISOR 403 F 57 White Active Y 72173 FINANCIAL SERVICE ADVISOR 403 F 57 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 58 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 58 White Active Y 72174 FINANCIAL SERVICE ADVISOR 403 F 59 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 61 White Active Y 72179 FINANCIAL SERVICE ADVISOR 403 F 62 White Active Y 15429 FINANCIAL SERVICE ADVISOR 403 F 67 Hispanic Active Y

Question \#3 Notes: For promotions, larger %= denominator EEOGroupActiveEesPromoEESRateofPROMO%PromoImpactRatioAdverseImpact-YesorNo Females Males Minority Non-Minority 40 \& Older 39 \& Younger