(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)
Not sure on which formulas to use. Thanks© BrainMass Inc. brainmass.com October 24, 2018, 11:56 pm ad1c9bdddf
Scatter plot, correlation coefficient and hypothesis tests are analyzed using Excel. The t test and critical value is calculated.
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.