Using the data given in the table below, answer the following questions. (Round
ID: 3063640 • Letter: U
Question
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)
30 2.76
50 6.58
38 1.50
11 6.30
40 6.11
33 6.62
35 3.59
28 6.15
16 8.25
49 4.23
(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 1formula42.mml.
t.025 ± =
(c) Calculate the t test statistic. (Negative value should be indicated by a minus sign.)
tcalc=
(d) Should we reject the null hypothesis of zero correlation?
Yes or No
Explanation / Answer
The statistical software output for this problem is:
Simple linear regression results:
Dependent Variable: y
Independent Variable: x
y = 7.0756923 - 0.056566434 x
Sample size: 10
R (correlation coefficient) = -0.34104474
R-sq = 0.11631151
Estimate of error standard deviation: 2.0845872
Parameter estimates:
Analysis of variance table for regression model:
Hence,
a) rcalc = -0.341
b) t0.025 = + 2.751
c) tcalc = -1.026
d) No
Parameter Estimate Std. Err. Alternative DF T-Stat P-value Intercept 7.0756923 1.934895 0 8 3.6568869 0.0064 Slope -0.056566434 0.055125438 0 8 -1.0261403 0.3348Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.