Using the data given in the table below, answer the following questions. (Round

Question

Using the data given in the table below, answer the following questions. (Round your final answers to 3 decimal places.) Order Size and Cost (n-1 1,045 1,097 790 862 1,163 1,141 837 956 768 647 1,106 1,023 Ship Cost (Y) 4,405 5,676 3,188 4,173 4,862 5,456 4,497 5,573 3,303 3,631 6,552 5,143 B Click here for the Excel Data File (a) Use Excel, MegaStat, or MINITAB to calculate the correlation coefficient cakc (b) Use Excel or Appendix D to find t025 for a two-tailed test ata-0ub 025 ± (c) Calculate the t test statistic. calc (d) Should we reject the null hypothesis of zero correlation? Yes O No show.pdf

Explanation / Answer

The statistical software output for this problem is:

Simple linear regression results:
Dependent Variable: y
Independent Variable: x
y = 109.48299 + 4.8224927 x
Sample size: 12
R (correlation coefficient) = 0.78809756
R-sq = 0.62109777
Estimate of error standard deviation: 666.52549

Parameter estimates:

Analysis of variance table for regression model:

Hence,

a) r = 0.788

b) t0.025 = + 2.228

c) t = 4.049

d) Yes

Parameter Estimate Std. Err. Alternative DF T-Stat P-value Intercept 109.48299 1151.2301 0 10 0.095100874 0.9261 Slope 4.8224927 1.1911191 0 10 4.0487075 0.0023

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.