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)
34	123,556.00
17	92,425.00
42	250,908.00
35	204,540.00
19	77,897.00
43	197,012.00
51	195,126.00
50	177,100.00
22	83,230.00
58	140,012.00
48	265,296.00
35	189,420.00
39	235,872.00
39	230,724.00
59	238,655.00
40	138,560.00
60	259,680.00
22	93,208.00
33	91,212.00
36	153,216.00
28	77,308.00
22	56,496.00
28	106,652.00
44	242,748.00
54	195,858.00
30	178,560.00
28	190,876.00
16	98,528.00
52	169,572.00
22	79,420.00
28	167,928.00
35	215,705.00
50	146,350.00

1. Use Data > Data Analysis > Correlation to compute thecorrelation check the Labels checkbox. Show work in excel.

2. Use the excel function =CORREL to compute the correlation. Ifanswer for #1 and 2 do not agree, there is an error. Show work inexcel.