please answer the following questions using the data. thanks!

Selection Data Used for Al Analysis PIP Resort Management Pleasure Island I-IV) - 11 months Facilities Maintenance (FMD Associates Completed Ini Group Non Minority Minority Male Female Qualified Applicant 124 79 142 61 Completed Werk Sample 123 74 Passed Work Sample 118 57 139 36 57 edwined 75 36 104 100 16 11 56 10 Facilities/Maintenance (FM) Associate Statistics Compared to the Relevant Population JOR CATEGORY: FRONT DESK GUEST RELATIONS ASSOCIATES CURRENT FM (%) Availability of FM Associates in Relevant Population (%) Male 65 Female Minority 32 Application 3 Questions 35 18 20 Assume that you are a consultant to PIP Resort Management. You need to evaluate the current selection practices used for this job. In later parts of the project, you will be making recommendations for changes. Statistics are important, but your interpretation of the statistics and use of them in decision-making is critical. Thus, you will need to justify/explain the rationale for your responses Answer each question by number. Show all work. Be sure to fully support/justify your responses. You may use outside sources; however, you must cite these outside sources using MLA, APA, or other accepted style. 1. Use the selection data (flow statistics) to calculate adverse impact for sex and minority status. Interpret each of the statistics Please show all work (e.g., formulas from Excel). a. Overall minority vs. non-minority b. Work sample minority vs. non-minority c. Interview minority vs non-minority d. Overall male vs. female c. Work sample male vs female f. Interview male vs female 2. Use the stock statistics to discuss whether or not there is underutilization of females and minorities. Show all work. Please make sure to interpret your findings. 3. Review the current selection process. Identify three potential problems (in terms of legal issues) that you see with the current selection system (e.g., interviews, tests, etc.). Briefly explain why these are concerns. The Resort Managers feel strongly about hiring people who "fit" with the organization. They would like to keep a method of determining "fit" in the selection system. Because business is growing, the company is open to investing money into the staffing systems (within reason). However, the most limited resource is time. The resort stays busy and everyone, including managers, has very little time to devote to "extra" activities like testing and interviewing. Below are the selection data for the past year for this job. Note that not all qualified applicants completed each step of the selection system. Some applicants chose to withdraw from the selection process (which is why you see a column showing the number who completed each step); others did not pass the selection test and did not advance to the next step in the selection process. Selection Data Used for Al Analysis - PIP Resort Management (Pleasure Island I-IV) - 12 months Facilities Maintenance (FM) Associates Qualified Applicants 124 Group Non-Minority Minority stake Female Completed Work Sample 123 74 141 56 Passed Work Sample LIN 57 139 36 Completed Interview 90 57 126 30 Passed Interview Hined 78 75 42 36 104 100 16 11 140 61 Qualified Applicants 124 Passed Work Sample Completed Interview Group Non-Miority Minity Male Female Completed Work Sample 123 74 11 56 57 1.19 Passed Interview Hired 75 36 104 TOO 16 11 57 126 10 142 61 Facilities/Maintenance (FM) Associate Statistics Compared to the Relevant Population JOR CATEGORY: FRONT DESK/GUEST RELATIONS ASSOCIATES CURRENT FM (%) Availability of FM Associates in Relevant Population (%) Male 82 65 Female 18 35 Minority 20 32 Application 3 Questions Assume that you are a consultant to PIP Resort Management. You need to evaluate the current selection practices used for this job. In later parts of the project, you will be making recommendations for changes. Statistics are important, but your interpretation of the statistics and use of them in decision-making is critical. Thus, you will need to justify/explain the rationale for your responses. Answer each question by number. Show all work. Be sure to fully support/justify your responses. You may use outside sources; however, you must cite these outside sources using MLA, APA, or other accepted style. 1. Use the selection data (flow statistics) to calculate adverse impact for sex and minority status. Interpret each of the statistics Please show all work (e.g., formulas from Excel). a. Overall minority vs. non-minority b. Work sample minority vs. non-minority c. Interview minority vs. non-minority d. Overall male vs. female e. Work sample male vs female f. Interview male vs. female 2. Use the stock statistics to discuss whether or not there is underutilization of females and minorities. Show all work. Please make sure to interpret your findings