Online Shopping

/in /by
  • This is an individual assignment. You can discuss with your friends but you need to write up the assignment on your own.
  • Use Excel to do the assignment #3. Label the answers and submit it with your name and ID#.

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 3 Data file, the data show the age of respondents and their answer to the question, “how many minutes do you browse online retailers per week?”

Please complete the following tasks using Excel.

  1. Construct a scatter diagram for the age of respondentsandbrowsing time (min/week)using the first as an independent variablex and the second as a dependent variable y. Find the regression equation and plot the regression line.(Do not forget about the label, regression equation, coefficient of determination r2 and axis titles). {5}

Does it seem that the variables are linearly correlated? How?{1}

  • Interpret the coefficient of determination r2. {2}
  • Findand interpretthe coefficient of correlationr. {2}
  • Find andinterpret the slope of the regression line. {2}
  • Using the regression equation find the most likely browsing timefor a 53-year-old person. {2}
  • Does there appear to be a significant linear relationship between the age of respondentsandbrowsing time (min/week)in the population of all online shoppers at 1%significance level? {6}