Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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 Yes

Explanation / 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.0018