Using the data given in the table below, answer the following questions. (Round
ID: 3057512 • Letter: U
Question
Using the data given in the table below, answer the following questions. (Round your final answers to 3 decimal places.) Order Size and Shipping Cost (n = 12 Orders (X 1,084 1,078 753 866 1,190 1,127 836 917 Ship Cost (Y) 4,491 5,648 3,190 4,327 4,852 5,428 4,492 5,526 3,386 3,697 6,668 5,008 643 1,135 1,032 he ata (a) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient rcalc (b) Use Excel or Appendix D to find t025 for a two-tailed test at a = 0.0 t.025 (c) Calculate the ttest statistic lcExplanation / Answer
The statistical software output for this problem is:
Simple linear regression results:
Dependent Variable: y
Independent Variable: x
y = 539.25407 + 4.3822025 x
Sample size: 12
R (correlation coefficient) = 0.76190518
R-sq = 0.5804995
Estimate of error standard deviation: 689.49396
Parameter estimates:
Analysis of variance table for regression model:
Hence,
a) rcalc = 0.762
b) t0.025 = + 2.634
c) tcalc = 3.720
Parameter Estimate Std. Err. Alternative DF T-Stat P-value Intercept 539.25407 1142.9771 0 10 0.47179779 0.6472 Slope 4.3822025 1.1780338 0 10 3.7199293 0.004Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.