answer the following question: 1. Write the regression equation. 2. Interpret th

Question

answer the following question: 1. Write the regression equation. 2. Interpret the regression constant and regression coefficient, 3. Forecast a value for the dependent variable, Test the significant of the regression coefficient at an alpha level of .05, Test the overall significant of the regression model,and Interpret the coefficient of determination. These questions are to be answered using excel or minitab. Do not solve by hand.

Explanation / Answer

so, after doing the things in exce, we copy here the outputs.

because as excel is menu-driven, i cant show the code as we could do in r.

1. days_absent=  8.0978 -0.3442*distance_to_work

2. if distance to work is zero, the average no. of days absent is 8.09783 <--regression constant

for each mile increase in distance the no of days absence in work decreses by 0.3442 days

3.the forcated value will be given by putting the given values at places of distance_to_work.

we get the forcasted values :

7.753623 7.065217 6.721014 6.032609 5.344203 4.655797 3.967391 3.278986
  
3.278986 1.902174

4. the p value for the regression constant is 8.41e-06 which is close to zero. so, this constant cant be taken as zero.

the p value for the regression coefficient is  0.00218 which is close to zero. so, this constant cant be taken as zero

5.for the overall significance

F-statistic: 19.67 on 1 and 8 DF, p-value: 0.002183

so, the p value is close to zero. hence we say the model is better than random noise.

R-squared: 0.7109 , the coefficient of determination. so, clearly, the model is good enough.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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