Please see the screenshots below for the questions.

3 MGMT650 HW11 Summer21_Questions Q AutoSave . OFF Home Insert Draw Page Layout Formulas Data Review View Developer ? Tell me Share Comments Calibri (Body) * 11 AA ag Wrap Text v General Ex AY - O. $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Paste BIUV CvAv EE Merge & Center v Formatting as Table Styles Filter Select Data Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. 072 + X V fx D E G H K L M N P Q R S T B Studies have shown that the frequency with which shoppers browse Internet retailers is related to the frequency with which they actually purchase products and/or services online. The following data show respondents age and answer to the question "How many minutes do you browse online retailers per year?" Age (X) Time (Y) 16 307 17 285 19 267 22 343 22 393 287 253 28 364 28 251 248 433 319 226 321 336 302 476 395 473 342 539 455 326 565 385 590 507 333 426 261 625 252 615 42 10) Use Data > Data Analysis > Correlation to compute the correlation checking the Labels checkbox. HW11 Chi Square ANOVA Regression Cleaning Data with Outlier + + 98% ITAutoSave . OFF 3 MGMT650 HW11 Summer21_Questions Q Home Insert Draw Page Layout Formulas Data Review View Developer ? Tell me Share Comments Calibri (Body) * 11 AA ag Wrap Text v General IX V V Ex AY - O. Paste BIU BY CvAv EE Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates 072 B C D E F G H 1 J K L M N 0 P Q R S T 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 48 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. 51 c) Complete the chart by adding Trendline and checking boxes 52 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 CJ 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 73 74 75 76 77 78 HW11 Chi Square ANOVA Regression Cleaning Data with Outlier + IT + 98%AutoSave . OFF 3 MGMT650 HW11 Summer21_Questions Q Home Insert Draw Page Layout Formulas Data Review View Developer ? Tell me Share Comments Calibri (Body) * 11 AA ag Wrap Text v General IX V V [B Ex AY - O. Paste BIUV CvAv E E Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles Filter Select Data Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates 072 + X V fx A B C D E F G H J K L M N 0 P Q R S T 81 82 83 84 85 86 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 122 123 124 125 HW11 Chi Square ANOVA Regression Cleaning Data with Outlier + + 98%