50.1K

Verified Solution

Link Copied!

Studies have shown that the frequency with which shoppers browseInternet retailers is related to the frequency with which theyactually purchase products and/or services online. The followingdata show respondents age and answer to the question “How manyminutes do you browse online retailers per week?”

Age (X)	Time (Y)
13	5662
19	4549
16	3772
44	1872
32	2799
52	1355
39	1966
15	5682
40	1602
53	1186
48	1832
37	2253
36	2241
42	1001
30	2474
42	1943
28	3021
11	5682
32	2192
39	1784
23	2707
37	1801
17	4827
11	2693
18	4340
50	1399
52	1593
9	9154
41	1504
26	2627
30	2575
32	2711
53	2368

10) Use Data > Data Analysis > Correlation to compute thecorrelation checking the Labels checkbox.

11) Use the Excel function =CORREL to compute the correlation.If answers for #1 and 2 do not agree, there is an error.

12) The strength of the correlation motivates furtherexamination.

a) Insert Scatter (X, Y) plot linked to the data on this sheetwith Age on the horizontal (X) axis.

b) Add to your chart: the chart name, vertical axis label, andhorizontal axis label.

c) Complete the chart by adding Trendline and checking boxes

13) Read directly from the chart:

a) Intercept =

b) Slope =

c) R2 =

Perform Data > Data Analysis > Regression.

14) Highlight the Y-intercept with yellow. Highlight the Xvariable in blue. Highlight the total standard error in orange

SUMMARY OUTPUT