Explore BrainMass

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

    © BrainMass Inc. brainmass.com June 3, 2020, 11:44 pm ad1c9bdddf
    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.

    $2.19

    ADVERTISEMENT