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...

Q.png



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?

Q.png

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
Adjusted R Square 0.881
Standard Error 22.763
Observations 10.000
ANOVA
of SS MS F Significance F
Regression 1.000 34920.000 34920.000 67.395 0.000
Residual 8.000 4145.141 518.143
Total 9.000 39065.141 Coefficients 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

Top Answer

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

Sign up to 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
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online