Using the data given in the table below, answer the following questions. (Round your final answers to 3 decimal places.)
Moviegoer Snack Spending (n = 10)
Age (X) Spent (Y)
32 2.84
49 6.54
33 1.41
10 6.22
36 6.26
35 6.76
39 3.54
27 6.01
18 8.32
48 4.39
(a) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. (A negative value should be indicated by a minus sign.)
rcalc
(b) Use Excel or Appendix D to find t.025 for a two-tailed test at α = 0.05.
t.025
(c) Calculate the t test statistic. (A negative value should be indicated by a minus sign.)
tcalc
(d) Should we reject the null hypothesis of zero correlation?
multiple choice
No
Yes