1. Scatterplot and Correlation Studies
1. Scatterplot and Correlation
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. These data show the age of respondents and their answer to the question “How many minutes do you browse online retailers per week?”
Age Browsing Time (min/wk)
22 492
Need assignment help for this question?
If you need assistance with writing your essay, we are ready to help you!
OUR PROCESS
Order
Payment
Writing
Delivery
Why Choose Us: Cost-efficiency, Plagiarism free, Money Back Guarantee, On-time Delivery, Total Сonfidentiality, 24/7 Support, 100% originality
50 186
44 180
32 384
55 120
60 120
38 276
22 480
21 510
45 252
52 126
33 360
19 570
17 588
21 498
a) Calculate the associated correlation coefficient and discuss how strong you think the relationship is between the age and the browsing time. Use the Correlation procedures within Excel under Data > Data Analysis.
b) Find the correlation coefficient using the Excel function CORREL.
c) Set up a scatter (xy) diagram with Age on the horizontal axis. Add the chart name and axes descriptions to your chart.
d) Add a trendline to the diagram.
e) Find the equation of the regression line. (Hint: One way is by adding the equation to the trendline. Go to format trendline and find it there).
f) Predict the number of minutes spent by a 40-year old shopper.
g) Can you use this data to predict the number of minutes spent by a 75 year old shopper? How about a 35 year old?
