Explore BrainMass

Scatter plot, correlation coefficient, and a hypothesis test

This content was STOLEN 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 October 24, 2018, 11:56 pm ad1c9bdddf

Solution Summary

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

See Also This Related BrainMass Solution

Hypothesis Testing and Scatter Plots

I need help (step-by-step) with the following questions for my upcoming test. (please see attached). Please explain the process of figuring these questions out. I have an upcoming final and I need to know how to do these problems.

A random sample of eight quarterback listed in The Sports Encyclopedia: Pro Football, gave the following information.

Let x = height of a quarterback in inches, and let y = weight of a quarterback in pounds.
x 75 78 74 73 72 75 76 73
y 205 230 210 210 195 215 203 196

a) Draw a scatter plot.
b) Calculate the correlation coefficient
c) Make a conclusion based upon the correlation coefficient.
d) Calculate the equation of the regression line and draw the line in your scatter plot.
e) If a quarterback is x = 76 inches tall, what can you predict is the weight of this quarterback?
f) Calculate the coefficient of determination.
g) Interpret the coefficient of determination in terms of your data.
h) Calculate the stand error of the estimate.
i) Interpret the standard error of the estimate in terms of your data.
j) Construct a 95% prediction interval for the weight of the quarterback when the height is 70 inches and interpret the results.

View Full Posting Details