Homework SoursePlease conduct a full five step regressional analysis to ans
Please conduct a full (five step) regressional analysis to answer this question:
Within the sample data, is an increase in ratings associated with an increase the average cost for a 30-second ad? If so, how much?
Solution
The regression equation is
AC=b0+b1R
AC=Average Cost
R=rating
| Regression Statistics | |||||
| Multiple R | 0.936989 | ||||
| R Square | 0.877948 | ||||
| Adjusted R Square | 0.860512 | ||||
| Standard Error | 8701.883 | ||||
| Observations | 9 | ||||
| ANOVA | |||||
| df | SS | MS | F | Significance F | |
| Regression | 1 | 3.81E+09 | 3.81E+09 | 50.35248 | 0.000194 |
| Residual | 7 | 5.3E+08 | 75722776 | ||
| Total | 8 | 4.34E+09 | |||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | |
| Intercept | -4235.78 | 5495.898 | -0.77072 | 0.466087 | -17231.5 |
| Rating | 3174.889 | 447.4227 | 7.095948 | 0.000194 | 2116.902 |
