A personnel manager for a large corporation feels that there may be a relationsh

Question

A personnel manager for a large corporation feels that there may be a relationship between absenteeism, age and life status (single, married, divorced and other) of workers. He would like to develop a model to predict the number of days absent during a calendar year for workers using the independent variables above. A random sample of 20 workers was selected with the results presented below. Use Excel to analyze the data, print out the summary output and attach it to your submission Use the following: Y = Dependent variable; X1 = Age; X2 = Single; X3 = Married; X4 = Divorced. a) What is the prediction equation? b) What is the correlation coefficient? c) Is the overall model significant? Why? d) What is the coefficient of determination? e) What is the MSE? f) List the p-value of each independent variable and say whether it is significant to the model or not. Use a 0.05 level of significance. g) What is the predicted number of days absent for a 54 year old widower?

Explanation / Answer

a) The prediction equation is

The regression equation is
Days Absent = - 4.34 + 0.387 Age + 4.47 X2 + 2.95 X3 + 20.5 X4

b) The correlation coefficient is

c)

The overall model is significant because Significance F 0.00013 is less than level of significance 0.05

d)

The coefficient of determination = 76.4%

e)

MSE is 45.97

f)

Age is significant

X4 i.e. is Divorced is significant.

g)

The predicted number of days absent for a 54 year old widower is 37 days

Multiple R 0.874258274

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.