Explore BrainMass

Explore BrainMass

    Scatter plot, correlation coefficient, and a hypothesis 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 Megastat or Excel to calculate the correlation coefficient. (c) Use Excel to find t.05 for a two-tailed test. (d) Calculate the t test statistic (e) Calculate critical value of ra. (f) Can you reject p=0?

    Orders(X) Shipping (Y)
    1068 4489
    1026 5611
    767 3290
    885 4113
    1156 4883
    1146 5425
    892 4414
    938 5506
    769 3346
    677 3673
    1174 6542
    1009 5088

    Not sure on which formulas to use. Thanks

    © BrainMass Inc. brainmass.com May 20, 2020, 5:10 pm ad1c9bdddf

    Solution Summary

    Scatter plot, correlation coefficient and hypothesis tests are analyzed using Excel. The t test and critical value is calculated.