Question

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. The following data show respondents age and answer to the question “How many minutes do you browse online retailers per week?

Age (X)	Time (Y)
11	1851
12	984
12	841
14	1063
14	883
14	1044
15	985
18	902
19	1040
20	918
20	976
22	728
26	859
28	960
28	893
30	709
30	786
42	463
43	560
43	791
45	591
47	440
49	258
49	250
50	480
51	919
52	262
53	184
53	231
54	246
55	205
59	163
64	300

Use Data > Data Analysis > Correlation to compute the correlation checking the Labels checkbox.. Use the Excel function =CORREL to compute the correlation. If answers for #1 and 2 do not agree, there is an error.

Insert a scatterplot. Display the Equation on chart and R^2 value on the chart.

What is the intercept, slope and R^2?

Using your highlighted cells, what is the equation of the regression line (round to two decimal places)?

Use Excel to predict the number of minutes spent by a 41-year old shopper. Enter = followed by the regression formula. Enter the intercept and slope into the formula by clicking on the cells in the regression output with the results.

Is it appropriate to use this data to predict the amount of time that a 70-year-old will be on the Internet? If yes, what is the amount of time, if no, why?

Answer 1