Question
Shown below is a portion of an Excel output for a regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression
Shown below is a portion of an Excel output for a regression analysis relating Y (dependent variable) and X (independent variable).
| ANOVA | ||||
| df | SS | |||
| Regression | 1 | 24.011 | ||
| Residual | 8 | 67.989 | ||
| Coefficients | Standard Error | t Stat | P-value | |
| Intercept | 11.065 | 2.043 | 5.415 | 0.001 |
| x | -0.511 | 0.304 | -1.681 | 0.131 |
- What is the estimated regression equation that relates y to x?
- Is the regression relationship significant? Use a p-value and alpha = 0.05.
- What is the estimated value of y if x = 12?
- Interpret the meaning of the value of the coefficient of determination if it is 0.26 in this case. Be very specific.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Elementary Statisitcs
Authors: Barry Monk
2nd edition
1259345297, 978-0077836351, 77836359, 978-1259295911, 1259295915, 978-1259292484, 1259292487, 978-1259345296
