Several studies have found that the frequency with which shoppers browse internet retailers is related to the frequency with which they actually purchase products and/or services

online. In the Assignment 2 Data file, the data collected by Ryerson university students show the age of 60 respondents and their answer to the question,"how many minutes do you browse onlineretailers per week?"The students want to find out whether variables theage of respondents(years) and thebrowsing time(min/week) are linearly related to each other. If they are, then how strongly thebrowsing timedepends on theage of respondents.

Please complete the following tasks using Excel.

a.Construct a scatter diagram for theage of respondentsand thebrowsing time. Do not forget to label the axis. Does it seem that the variables are linearly correlated?

b.Find the coefficient of correlation. Find and interpret the coefficient of determination.

c.Find the regression equation and plot the regression line. Interpret the slope of the regression line. Can we interpret they-intercept? Why?

d. Ryerson students consider a group of 5 typical on-line shoppers.

Their ages are 29, 36, 47, 54, and 65 years. Using the regression equation find for each of them the most likely browsing time per week in minutes.

40 58 315 39 410 20 505 23 445 50 120 27 450 38 360 68 40 18 61 60 57 310 40 440 20 535 28 485 51 125 27 555 72 0 18 512 38 410 58 69 35 50 22 573 60 40 265Age of Respondent Browsing Time (min/week) 20 480 55 186 44 180 32 384 55 120 60 40 38 276 22 480 21 510 45 252 53 140 30 360 570 588 498 480 17 19 420 18 30 19 210 20 300 385 480 250 180 251 600 65 90 57 320 29 49 450 30 25 530 31 475 120 32 33 27 550 400 34 30 35 36 62 40 37 260 19 570 39 66 70 40 58 315