We give Excel output of regression analysis. Above output we give the regression

Question

We give Excel output of regression analysis. Above output we give the regression model and the number of observations, n, used to perform the regression analysis under consideration. Using the model, sample size n, and output:

Model: y = 0 + 1x1 + 2x2 + 3x3 +        Sample size: n = 30

(1) Report SSE, s2, and s as shown on the output. (Round your answers to 4 decimal places.)

(3) Report the total variation, unexplained variation, and explained variation as shown on the output. (Round your answers to 4 decimal places.)

(4) Calculate the F(model) statistic by using the explained variation, the unexplained variation, and other relevant quantities. (Round your answer to 2 decimal places.)

      

F(model)                 

Regression Statistics Multiple R .1732 R Square .0300 Adjusted R Square .0000 Standard Error .6380 Observations 30

Explanation / Answer

1)SSE =10.5728

s2 =0.4066

s=0.6380

2)

R2 =0.0300

Rbar2 =0.0000

3)Total variation =1.00 ~100%

unexplained variation =0.9700 ~97.0000%

Explained variation=0.0300 ~3.0000%

4)F model =0.2675

please revert for any clarification required

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

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