Question: Please I need answer in an excel solved sheet, thank you! Any descriptive answer will not be helpful at all. CASE: Performance Lawn Equipment, p

Please I need answer in an excel solved sheet, thank you!
Any descriptive answer will not be helpful at all.
CASE: Performance Lawn Equipment, p.323-324.Please respond fully to only the HR component of the case (Paragraph 2, Employee Retention worksheet) and submit your
trendlines, regression analysis, recommendations and analyses in a report.There is no page/length requirement for this assignment, instead grading will be determined on a thorough assessment of the problems presented in the case study. The data you need to analyze is in the Data folder in Module 1, and is attached below. You will only need to utilize one tab in the excel sheet for this project. If your version of excel does not have the Analysis ToolPak installed instructions on how to install the add-in are attached below.
This is paragraph 2:
In meeting with PLEs human resources director, Ms. Burke also discovered a concern about the high rate of turnover in its field service staff. Senior managers have suggested that the department look closer at its recruiting policies, particularly to try to identify the characteristics of individuals that lead to greater retention. However, in a recent staff meeting, HR managers could not agree on these characteristics. Some argued that years of education and grade point averages were good predictors. Others argued that hiring more mature applicants would lead to greater retention. To study these factors, the staff agreed to conduct a statistical study to determine the effect that years of education, college grade point average, and age when hired have on retention. A sample of 40 field service engineers hired ten years ago was selected to determine the influence of these variables on how long each individual stayed with the company. Data are compiled in the Employee Retention worksheet.
This is image of the worksheet:
 Please I need answer in an excel solved sheet, thank you!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!