Just need help with (a) and (c). The rest of the answers have already been verif
ID: 3350749 • Letter: J
Question
Just need help with (a) and (c).
The rest of the answers have already been verified as being correct.
Here is the problem:
Using the data given in the table below, answer the following questions. (Round your final answers to3 decimal places.) Order Size and Shipping Cost (n = 12 Orders (X) 1,100 1,086 770 854 1,112 1,191 847 952 738 635 1,114 1,061 Ship Cost (Y) 4.438 5,681 3,226 4,270 4,855 5,415 4,410 5,520 3,342 3,604 6,545 5,172 Xc at (a) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient. calc (b)Use Excel or Appendix D to find to2s for a tw o-tailed test at a U.Ub t,025 2.228 (c) Calculate the t test statistic. alc (d) Should we reject the null hypothesis of zero correlation? 0 YesExplanation / Answer
The statistical software output for this problem is:
Simple linear regression results:
Dependent Variable: Ship Cost (Y)
Independent Variable: Orders (X)
Ship Cost (Y) = 423.54601 + 4.4847686 Orders (X)
Sample size: 12
R (correlation coefficient) = 0.79935213
R-sq = 0.63896383
Estimate of error standard deviation: 640.19429
Parameter estimates:
Hence,
a) rcalc = 0.799
c) tcalc = 4.207
Parameter Estimate Std. Err. Alternative DF T-Stat P-value Intercept 423.54601 1034.7149 0 10 0.40933597 0.6909 Slope 4.4847686 1.0660492 0 10 4.2069057 0.0018Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.