07 115 points).Shown below is a portion of an Excel output from a linear regress

Question

07 115 points).Shown below is a portion of an Excel output from a linear regression. Answer the questions below. Uise specific mombers from the Excel owiput to justifyo your answers rS 7322 2441 304 .93-71 Residual Total 186 189 1493 (a) Was this a simple or multiple linear regression? Justify briefly (b) How many observations were there in the dataset used for this regression? Justify briefly. (c) What is the R2 value for this regression? Show calculations (d) The regression output for the intercept is shown below Cef icients Standard Error Sal-P-value-lower 95% upper 95% Lower91w.tnerylth- Intercept 83.03 6.96-11.92-000 69.29 96.77 67-50 i. What was the 'confidence level' that was used when doing the regression in Excel? Justify. ii. What does the value of 11.92 for the t-Stat mean? iii What do the Lower95% and Upper95% numbers mean?

Explanation / Answer

solutionA:

its a simple regression

Model is significanct since p<0.05 from ANOVA table.

Solutionb:

nol of observations=total df+1

there are 189+1=190 observations

Solutionc:

confidence level used=95%

Solutiond:

t=coefficient/std error

=83.03/6.96

=11.92

Solutiontiii:

lowest 95%=69.29

upper 95%=96.77

Related Questions

Navigate

• Browse (All)
• Browse
• Subjects

---

---

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