In: Statistics and Probability
After working with the data, you realize that since Half-Foods was acquired, its staffing and sales strategies has changed quite drastically and therefore the historical data is not valid any more. Especially, there has been a significant reduction of staff. So you decide to collect new data from your stores. In the table below, you can find the average number of employees and the sales for each Half-Foods store in the past six months. Build a regression model that uses average number of employees to explain sales.
|
|
Based on this analysis, how many additional sales (in $M) does an extra employee bring?
What is the p-value of the coefficient of Average Number of Employees?
Independent variable (X): Average Number of Employees
Dependent variable (Y): Sales ($M)
Following is the output of regression analysis generated by excel:
SUMMARY OUTPUT | ||||||
Regression Statistics | ||||||
Multiple R | 0.89351455 | |||||
R Square | 0.79836825 | |||||
Adjusted R Square | 0.796152517 | |||||
Standard Error | 41.30716232 | |||||
Observations | 93 | |||||
ANOVA | ||||||
df | SS | MS | F | Significance F | ||
Regression | 1 | 614803.6728 | 614803.6728 | 360.3178 | 2.12023E-33 | |
Residual | 91 | 155271.6309 | 1706.281659 | |||
Total | 92 | 770075.3038 | ||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | |
Intercept | 33.71137091 | 9.091222786 | 3.708122846 | 0.000359 | 15.65277407 | 51.769968 |
X | 11.37178473 | 0.599081301 | 18.98203918 | 2.12E-33 | 10.18178335 | 12.561786 |
The required regression equation is
y' = 33.711 +11.372*x
That is for each additional employee sales is increased by 11.372 ($M) units.
The p-value of the coefficient of Average Number of Employees is 0.0000