Question: Highlight the Y-intercept with yellow. Highlight the X variable in blue. Highlight the R Square in orange SUMMARY OUTPUT Regression Statistics Multiple R 0.68579684 R
Highlight the Y-intercept with yellow. Highlight the X variable in blue. Highlight the R Square in orange SUMMARY OUTPUT Regression Statistics Multiple R 0.68579684 R Square 0.470317306 Adjusted R Square 0.453230767 Standard Error 46017.98564 Observations 33 ANOVA df SS MS F Significance F Regression 1 5.83E+10 5.83E+10 27.5256 1.06E-05 Residual 31 6.56E+10 2.12E+09 Total 32 1.24E+11 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 39165.82182 24841.66 1.576619 0.125035 -11499.1 89830.72065 -11499.1 89830.72065 X Variable 1 3339.768564 636.5726 5.246485 1.06E-05 2041.47 4638.066932 2041.47 4638.066932
1. Use Excel to predict the number of minutes spent by a 22-year old shopper.
2. Enter = followed by the regression formula.
3. Enter the intercept and slope into the formula by clicking on the cells in the regression output with the results.
4. Is it appropriate to use this data to predict the amount of time that a 9-year-old will be on the Internet?
5.If yes, what is the amount of time, if no, why?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help