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)
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

use Data>Data Analysis > Correlation to compute the correlation checking the label checkbox.
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.
a. insert Scatter (X, Y) plot linked to the data on this sheet with Age on the horizontal (X) axis.

b. Add to your chart name, vertical axis label, and horizontal axis label.
c. Complete the chart by adding Trendline and checking boxes

Answer 1

using data analysis tool the correlation matrix is given as and correlation between Age(x) and Time(Y) is -0.8112

	Age(x)	Time(Y)
Age(x)	1
Time(Y)	-0.8112	1

using the excel function function= correl function the correlation between Age(x) and Time(Y) is -0.8112

(a,b and c) please find the scatter plot