Question

11)	Use Data > Data Analysis > Correlation to compute the correlation checking the Labels checkbox.
12)	Use the Excel function =CORREL to compute the correlation. If answers for #1 and 2 do not agree, there is an error.
	The strength of the correlation motivates further examination.
13)	a)  Insert Scatter (X, Y) plot linked to the data on this sheet with Age on the horizontal (X) axis.
14)	b) Add to your chart: the chart name, vertical axis label, and horizontal axis label.
15)	c) Complete the chart by adding Trendline and checking boxes
	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

Answer 1

11.  

	Age (X)	Time (Y)
Age (X)	1
Time (Y)	-0.84508	1

12. r = -0.84508