# Significance of Correlation: Conducting a T Test

(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

Please see the attachments.

Answers

(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.