Explore BrainMass

# Significance of Correlation: Conducting a T Test

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

(a) Make a scatter plot of the data. What does it suggest about the correlation between X and Y?
(b) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient.
(c) Use Excel or Appendix D to find t.05 for a two-tailed test.
(d) Calculate the t test statistic.
(e) Calculate the critical value of ra.
(f) Can you reject p = 0?

Moviegoer Spending (\$) on Snacks Movies
Age (X) Spent (Y)
30 2.85
50 6.50
34 1.50
12 6.35
37 6.20
33 6.75
36 3.60
26 6.10
18 8.35
46 4.35

https://brainmass.com/statistics/correlation/significance-correlation-conducting-test-295336

#### Solution Preview

(a) Make a scatter plot of the data. What does it suggest about the correlation between X and Y?

Since the points are widely scattered without clustering round the line, the scatter plot suggests a weak negative correlation between X and Y.
(b) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient.

Age ...

#### Solution Summary

The expert examines the significance of correlation conducting a T Test.

\$2.19