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.