# 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

© BrainMass Inc. brainmass.com May 20, 2020, 5:10 pm ad1c9bdddfhttps://brainmass.com/statistics/hypothesis-testing/number-of-orders-and-shipping-costs-scatter-plot-correlation-coefficient-and-a-hypothesis-test-210758

#### Solution Summary

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