2. Using excel analysis functions, determine the employee characteristics that you would recommend Gizmo Manufacturing look for when hiring new personnel. It is highly recommended that you use PivotTables as part of your analysis.

3. Prepare a report based on your findings (which should include several forms of graphical representation) for your recommendations.

Project 22: Turnover Rates Employee is experiencing severe wor trol problems. The majority of the company's workers perform a variety of tasks and are paid by the hour. The company currently tests potential applicants to ensure that they have the skills necessary for the intense mental concentration and dexterity required to ill the positions. Since significant costs are associated with employee turnover, Gizmo Manufacturing wants to find a way to predict which applicants have the characteristics of being a short-term versus a long-term employee. 1. Review the information that Gizmo Manufacturing has collected from two of its data sources. turnover rates are at an all-time high at Gizmo's Manufacturing plants. The company ker retention issues, which are leading to productivity and quality con- The first data file, AYK22_Data_A.xlsx, contains information regarding employee wages. The second data file, AYK22_Data_B.xisx, contains information regarding employee retention. 2. Using Excel analysis functions, determine the employee characteristios that you would recom- mend Gizmo Manufacturing look for when hiring new personnel. it is highly recommended that you use PivotTables as part of your analysis. 3. Prepare a report based on your findings (which should include several forms of graphical rep- resentation) for your recommendations. Data Files: AYK22 Data A.xisx and AYK22 Data B.xlsx Project 22: Turnover Rates Employee is experiencing severe wor trol problems. The majority of the company's workers perform a variety of tasks and are paid by the hour. The company currently tests potential applicants to ensure that they have the skills necessary for the intense mental concentration and dexterity required to ill the positions. Since significant costs are associated with employee turnover, Gizmo Manufacturing wants to find a way to predict which applicants have the characteristics of being a short-term versus a long-term employee. 1. Review the information that Gizmo Manufacturing has collected from two of its data sources. turnover rates are at an all-time high at Gizmo's Manufacturing plants. The company ker retention issues, which are leading to productivity and quality con- The first data file, AYK22_Data_A.xlsx, contains information regarding employee wages. The second data file, AYK22_Data_B.xisx, contains information regarding employee retention. 2. Using Excel analysis functions, determine the employee characteristios that you would recom- mend Gizmo Manufacturing look for when hiring new personnel. it is highly recommended that you use PivotTables as part of your analysis. 3. Prepare a report based on your findings (which should include several forms of graphical rep- resentation) for your recommendations. Data Files: AYK22 Data A.xisx and AYK22 Data B.xlsx