Studies have shown that the frequency with which shoppers browse internet retailers is related to the frequency with which they actually purchas products and/or services online. The following data sho respondents age and answer to the question "how many minutes do you browse online retailers per year?"

Arial 10 MAZ A B C D E F G H 4 6 Age (X) Time (Y) 7 16 420 8 17 269 19 315 10 22 337 11 22 243 12 459 13 414 14 224 15 381 16 412 17 576 18 333 19 551 20 548 21 626 22 35 521 23 35 562 24 36 699 25 39 643 26 39 455 27 40 666 28 42 553 29 43 459 30 44 525 31 48 659 32 50 507 33 50 612 34 51 710 35 52 378 36 54 566 37 58 652 + HW11 Chi Square ANOVA Regression Cleaning Data with Outlier Sheet 4 of 5 PageStyle_Regression Type here to search O hpArial 10 V - % 00 M42 & E = A B C D G H 37 58 652 38 59 725 30 60 695 40 41 42 10) Use Data > Data Analysis > Correlation to compute the correlation checking the Labels checkbox. 43 44 45 11) Use the Excel function =CORREL to compute the correlation. If answers for #1 and 2 do not agree, there is an error. 46 47 45 The strength of the correlation motivates further examination. 49 12 a) Insert Scatter (X, Y) plot linked to the data on this sheet with Age on the horizontal (X) axis. 50 b) Add to your chart: the chart name, vertical axis label, and horizontal axis label. c) Complete the chart by adding Trendline and checking boxes 57 53 Display Equation on chart 54 55 Display R-squared value on chart 56 57 58 59 60 Read directly from the chart: 61 13 ) a) Intercept = 62 b) Slope = 63 C) R? = 64 65 Perform Data > Data Analysis > Regression. 66 67 14) Highlight the Y-intercept with yellow. Highlight the X variable in blue. Highlight the R Square in orange 68 69 70 71 72 + HW11 Chi Square ANOVA Regression Cleaning Data with Outlier Sheet 4 of 5 PageStyle_Regression Eng Type here to search O hpArial 10 a a a |a - B . IS = 35 % 00 1 42 & E = A B D F G H 85 96 87 88 89 90 15 Use Excel to predict the number of minutes spent by a 22-year old shopper. Enter = followed by the regression formula. 91 Enter the intercept and slope into the formula by clicking on the cells in the regression output with the results. 92 93 16 Is it appropriate to use this data to predict the amount of time that a 9-year-old will be on the Internet? 94 95 If yes, what is the amount of time, if no, why? 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 1 4 + HW11 Chi Square ANOVA Regression Cleaning Data with Outlier Sheet 4 of 5 PageStyle_Regression English (USA) Type here to search O M esc 12 RX 15 16 4) (7 4) 18