Assignment: Using the provided dataset (note worksheet tabs ACTIVE, PROMO, TERM) and files provided, complete the assigned questions. Refer to article "Avoiding Adverse Impact in Employment Practices" for background, definitions, and calculations. 1. Using the ACTIVE worksheet calculate the ACTIVE workforce summarizing each demographic group below by total number & as a percentage to entire workforce. Show your calculations. a. b . Sex (males, females) Minority (total non-White ethnicities) & Non-Minority (total White) C. Age (total under 40; and 40 and over) 2. 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. Fregative transactions, freeminations, theest rate (most favored) for the group is placed in thenerator 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 3. 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. Flighest rate (most favored) for the group is placed in 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) 4. Summarize your observations based on your adverse impact calculations. Identify what corrective action should be taken to avoid adverse impact