Jack is concerned with the high worker turnover rate for front-level staff. Other departments have requested Jack to examine the firm's recruiting policies in order to identify the characteristics of individuals that can lead to greater retention. The HR department could not reach an agreement on these characteristics.

Some members of the HR department claimed that years of education and GPA (grades) were the best predictors. Other members contended that hiring more mature candidates would lead to greater retention. To settle this dispute, the HR department decided to conduct a statistical study to determine the effect university GPA, years of Education, and age when hired have on retention. A sample of 40 front-line workers hired ten years ago was selected to determine the influence of these variables on how long each worker stayed with the company. Data are compiled in the Employee Retention worksheet.

Jack wants you to use trendlines and regression analysis to assess this data included in theWorker Retentionworksheet. Summarize your work (including critical insights) in your group's formal report with all appropriate analysis and results.

A B C D E F G 19 6.5 H 16 3.10 26 M 20 6.3 13 2.98 21 M 21 6.2 16 2.71 23 22 5.9 M 13 2.95 20 F 23 5.8 18 3.36 25 M 24 5.4 16 2.75 24 25 5.1 17 2.48 32 M 26 4.8 14 2.76 28 M 27 4.7 16 3.12 25 F 28 4.5 13 2.96 23 M 29 4.3 16 2.80 25 M 30 4 17 3.57 24 M