Gateway Estate Lawn Equipment Co. Performance Lawn Equipment The case solution
Question: 2
As the human resources director meeting informed that there is high turnover rate in the field service staff. So the human resources department was suggested to focus on the hiring and recruiting policies and specially on the characters of individuals at the time of hiring of interview. they think that these character has impact on the employees retention. So they are trying to come up with the individual character that have impact on retention of individual. In a meeting they came to list some individual characters that must be considered such as education years, GPA, and age are good predictors of individual retention. But human resources director is not fully agreed on it. So they want to know whether it has significant impact on retention of not for that we performed statistical methods such as regression to know the fact.
As we-performed regression analysis, after which we came to know that the years of education variable are not predictors of retention. Higher education does not indicate to the significance of greater possibility of retention, because the coefficient of years of education is 0.68, but the p-value is greater than 0.05, which means the years of education variable is not the predictor of the employees’ retention. On the other hand,there is a positive relationship between the college GPA and the employees’ retention, and the hypothesis is rejected because the p-value is 0.5745, which is greater than 0.05. So, the years of education and college GPA are not the predictors of employees’ retention.
Only age, at the time of hiring an employee, is the predictor of employees’ retention, because the p-value is 0.03, which is less than 0.05.It shows the significance of the hypothesis.the t-states is greater than 2, and p-value is less than 0.05. so it shows significance of hypothesis. The confidence interval does not contain zero so it is also showing significance.
The R-square is only 15% so this model is only have 15% explanatory power of variation in employees retention or employees turnover.
Regression Statistics | ||||||||
Multiple R | 0.387559901 | |||||||
R Square | 0.150202677 | |||||||
Adjusted R Square | 0.079386234 | |||||||
Standard Error | 2.725526994 | |||||||
Observations | 40 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 3 | 47.26784375 | 15.75594792 | 2.1210141 | 0.114635312 | |||
Residual | 36 | 267.4259062 | 7.428497396 | |||||
Total | 39 | 314.69375 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | -2.7371 | 4.5041 | -0.6077 | 0.5472 | -11.8719 | 6.3977 | -11.8719 | 6.3977 |
Yrs. Education | -0.0671 | 0.3552 | -0.1888 | 0.8513 | -0.7874 | 0.6533 | -0.7874 | 0.6533 |
College GPA | 0.6800 | 1.1836 | 0.5745 | 0.5692 | -1.7204 | 3.0803 | -1.7204 | 3.0803 |
Age | 0.2915 | 0.1350 | 2.1588 | 0.0376 | 0.0177 | 0.5654 | 0.0177 | 0.5654 |
As we come to the conclusion that education years and CGPA does not have significant impact the retention. So we can perform regression only for age to know the significance of impact of age on retention.
Regression Statistics | ||||||||
Multiple R | 0.3766582 | |||||||
R Square | 0.1418714 | |||||||
Adjusted R Square | 0.11928907 | |||||||
Standard Error | 2.66580544 | |||||||
Observations | 40 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 44.64604247 | 44.64604247 | 6.282407021 | 0.016591921 | |||
Residual | 38 | 270.0477075 | 7.106518619 | |||||
Total | 39 | 314.69375 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | -2.0148657 | 3.042483099 | -0.662243838 | 0.511811593 | -8.174050713 | 4.144319346 | -8.174050713 | 4.144319346 |
X Variable 1 | 0.30029287 | 0.119806943 | 2.506473024 | 0.016591921 | 0.057756394 | 0.542829346 | 0.057756394 | 0.542829346 |
The age also does not have significant impact alone.
Question: 3
From our regression analysis; we came to the equation y= 58.184-0.293X. The R-square is 84.9%, which shows 84.9% variation in time of production, which is explained by technology. The new product technology reduces the time of production because the p-value of the coefficient is nearly zero, so it's significant.
Regression Statistics | ||||||||
Multiple R | 0.921 | |||||||
R Square | 0.849 | |||||||
Adjusted R Square | 0.846 | |||||||
Standard Error | 1.818 | |||||||
Observations | 50 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 891.55 | 891.55 | 269.67 | 0.00 | |||
Residual | 48 | 158.69 | 3.31 | |||||
Total | 49 | 1050.25 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 58.184 | 0.522 | 111.442 | 0.000 | 57.134 | 59.233 | 57.134 | 59.233 |
X Variable 1 | -0.293 | 0.018 | -16.422 | 0.000 | -0.328 | -0.257 | -0.328 | -0.257 |
......................
This is just a sample partial case solution. Please place the order on the website to order your own originally done case solution.