Question: Please use excel so I can attach the files to word STAT 1112 Online Shopping Several studies have found that the frequency with which shoppers
Please use excel so I can attach the files to word

STAT 1112 Online Shopping 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 Business School students show the age of 60 respondents and their answer to the question, "how many minutes do you browse online retailers per week?" The students want to find out whether variables the age of respondents (years) and the browsing time (min/week) are linearly related to each other. If they are, then how strongly the browsing dime depends on the age of respondents. Please complete the following tasks using Excel. . Construct a scatter diagram for the age of respondents and the browsing time. Do not forget to label the axis. Does it seem that the variables are linearly correlated? Comeisuon Coofficiant 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 the y-intercept? Why? d. 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
