Share
Explore BrainMass

Scatter plot, correlation coefficient, and a hypothesis test

(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

Solution Summary

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

$2.19