View the step-by-step solution to:

# Use the regression output below from Excel to answer the following questions. When you type in your answers, type them EXACTLY as the appear on the...

1.What is the slope for the regression equation?

2. What is the intercept for the regression equation?

3. What is the LaTeX: R^2 R 2 for the regression equation?

4. What is the sample size for this example?

5. What is the standard deviation of the residuals?

6. What is the standard error for the slope?

7. What is the t-statistic for the slope?

8. What is the p-value for the slope t-statistic?

9. What is your decision about the t-statistic for the slope based on the p-value, assuming an LaTeX: alpha:=:0.05 α = 0.05 (Reject or Fail to reject)?

Reject

10. What is the residual for the 10th observation in the sample?

Use the regression output below from Excel to answer the following questions. When you type in
your answers, type them EXACTLY as the appear on the output. SUWARY OUTPUT Regression Statistics Multiple R 0.945
R Square 0.894
Standard Error 22.763
Observations 10.000
ANOVA
of SS MS F Signiﬁcance F
Regression 1.000 34920.000 34920.000 67.395 0.000
Residual 8.000 4145.141 518.143
Total 9.000 39065.141 Coefﬁcients Standard Error (Stat P-chlue Lower 95 96 Upper 95% Lower 95.0% Upper 95. 0% Intercept 67.048 20.905 3.207 0.012 18.841 115.254 18.841 115.254
Times Ad Aired 5.817 0.709 8.209 0.000 4.183 7.451 4.183 7.451
RESIDUAL OUTPUT
Predicted
Househoi'd
Observation Expomres M Residuals
1.000 352.066 7.534
2.000 311.349 -15.249
3.000 241.548 30.052
4.000 218.282 32.818
5.000 247.365 -18.065
6.000 183.381 3.519
7.000 189.198 —2. 898
8.000 206.648 -33.948
9.000 154.298 11.702 10.000 177.565 -15.465

Lets solve the questions. 1 Slope is obtained reading the value of Time Ad Aired coefficient =5.817 2. intercept= 67.048 3.... View the full answer

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents