The manager of PLE company has approached you to find out the reasons to know why there is high employee turnover in the company. The company has provided you with a datasheet that contains information about the years of employee education, college grade point and the age of employees along with their years of service in PLE. Would you be able to help the management understand the predictors of employee retention in PLE?

Please provide a regression analysis via an excel data analysis using the data in the table above

Provide an excel scatter plot with regression function showing intercept, slope

Advice on the nature of regression or relationship 

Provide recommendation to PLE Company on the reasons of High employee turnover in the company

 

Transcribed Image Text:

Years of Education 18 16 18 18 15 15 15 15 15 13 25 25 24 25 5 35 25 24 25 25 24 25725425 20 25 24 32 25 25 25 25 24 25 25 24 25 1 24 22 25 22 25 25 22 24 156813 16 16 17 16 18 13 13 16 16 16 16 13 18 16 17 14 16 16 13 16 17 16 16 15 16 14 16 13 16 Age 18 33 26 23 23 32 34 28 23 23 26 23 28 23 26 23 23 21 23 26 College GPA Years of Service with PLE 3.01 10 2.78 10 3.15 10 10 9.6 8.5 8.4 3.86 2.58 2.96 3.56 2.64 3.43 2.75 2.95 2.50 2.86 2.38 3.47 3.10 2.98 2.71 2.95 3.36 2.75 2.48 2.76 3.12 2.96 2.80 3.57 3.00 2.86 3.19 3.50 2.84 3.13 1.75 2.98 2.13 2.79 3.15 1.84 3.79 8.4 2 5 6 75 15 2 8 5 6 2 8.2 7.9 7.6 7.5 7.2 6.8 6.5 6.3 6.2 5.9 coco 5.8 5. 4. 5.4 5.1 4.8 75 4.7 4.5 4.3 4 3.9 3.3. 77 3.7 3.7 3.3. 75 4 3.7 3.5 3.4 2.5 1.8 coco in i 1.5 0.9 0.8 0.7 73 0.3 Years of Education 18 16 18 18 15 15 15 15 15 13 25 25 24 25 5 35 25 24 25 25 24 25725425 20 25 24 32 25 25 25 25 24 25 25 24 25 1 24 22 25 22 25 25 22 24 156813 16 16 17 16 18 13 13 16 16 16 16 13 18 16 17 14 16 16 13 16 17 16 16 15 16 14 16 13 16 Age 18 33 26 23 23 32 34 28 23 23 26 23 28 23 26 23 23 21 23 26 College GPA Years of Service with PLE 3.01 10 2.78 10 3.15 10 10 9.6 8.5 8.4 3.86 2.58 2.96 3.56 2.64 3.43 2.75 2.95 2.50 2.86 2.38 3.47 3.10 2.98 2.71 2.95 3.36 2.75 2.48 2.76 3.12 2.96 2.80 3.57 3.00 2.86 3.19 3.50 2.84 3.13 1.75 2.98 2.13 2.79 3.15 1.84 3.79 8.4 2 5 6 75 15 2 8 5 6 2 8.2 7.9 7.6 7.5 7.2 6.8 6.5 6.3 6.2 5.9 coco 5.8 5. 4. 5.4 5.1 4.8 75 4.7 4.5 4.3 4 3.9 3.3. 77 3.7 3.7 3.3. 75 4 3.7 3.5 3.4 2.5 1.8 coco in i 1.5 0.9 0.8 0.7 73 0.3