Attached 3 files below
1. assignment Instruction file: Employee Retention Exercise_Assignment 2
1. excel data file: Employee Attrition Summer 2022
2. a friend’s version of this assignment: Employee Retention Exercise_friendsversion
Craft your answers as if you were communicating your insights to the heads of R&D, Sales, Marketing and HR, and make your answers easy to understand for non-technical leaders. Do not include programming code or data tables. Use charts only if they make your answers easier to understand.
1. Using the data provided, explain whether the two assertions of the head of HR as described in the problem statement are correct. (20 points)
2. Describe at least three variables in the dataset that are common across employees in R&D, marketing and sales who are at a disproportionate risk for leaving . The work can be conducted in Excel using pivot tables, but you are free to use any tool that you wish. There is no need to explain what approach you used. If the variables that you identify appear to be related in any way, summarize the theme(s) that you see in these variables so you can communicate your findings to the head of HR. (20 points)
3. The Chief Analytics Officer for the company wants to demonstrate the value of talent analytics to the executive committee by supporting the R&D division. You do not believe that R&D is the best division to support. Which division would you support to prove the value that you can generate? Develop the strategic rationale that will convince the Chief Analytics Officer and the executive committee, which includes the heads of R&D, Sales, Marketing and HR, of your choice of the division to support. (20 points)
4. Develop three recommendations for the leader of the division that you are supporting to address the attrition risk factors that you identified in question 2. Remember that interventions like salary, promotions, and stock options are commonly set at the enterprise level, not the division level. What is the top recommendation that you would make to the head of the division that you chose to support? Explain the rationale for the top recommendation that you chose. (20 points)
5. Design a rapid experiment (review what you learned in Research Design) for your top recommendation to determine whether your hypothesis is correct and you can successfully mitigate attrition. What information beyond employee survey data would you want to track? How would you collect and report the data? (20 points)