Please answer 14 - 16 and provide excel formulations.

14 1 Highlight the Y-intercept with yellow. Highlight the X variable in blue. Highlight the R Square in orange SUMMARY OUTPUT Multiple R 0. 68573684 R Square 0.470317306 Adjusted R Squ 0.453230767 Standard Error 46017.98564 Observations 33 ANOVA F Regression 1 6E+10 BE+10 27.526 18-05 Residual 31 7E+10 ZE+09 Total 32 1E+11 Upper 35. 02 Intercept 39165.82182 24842 1.5766 0. 125 -11499 89830.7206 -11499 39830.72065 X Variable 1 3339. 768564 636.57 5.2465 1E-05 2041.5 4638.06693 2041.5 4638.066932 Use Excel to predict the number of minutes spent by a 22-year old shopper. Enter = followed by the regression formula. Enter the intercept and slope into the formula by clicking on the cells in the regression output with the results. 16) Is it appropriate to use this data to predict the amount of time that a 9-year-old will be on the Internet? If yes, what is the amount of time, if no, why