Answer the following questions using the data given below.
Order Size and Shipping
Cost (n = 12)
Orders (X) Ship Cost (Y)
1,068 4,489
1,026 5,611
767 3,290
885 4,113
1,156 4,883
1,146 5,425
892 4,414
938 5,506
769 3,346
677 3,673
1,174 6,542
1,009 5,088
Use Excel to make a scatter plot of the data. Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display equation on chart and Display R-squared value on chart.
Picture Click here for the Excel Data File
(a) Choose the right option.
An increase in orders leads to an average increase in shipping cost.
An increase in orders leads to an average decrease in shipping cost.
(b) Choose the correct statement.
The intercept is meaningful in this case.
The intercept is not meaningful in this case.
(c) Calculate R2. (Round your answer to 4 decimal places.)
R2 (d) Interpret the R2. (Round your answer to 2 decimal places.)
The percentage of the variation in shipping costs that is explained by number of orders is %.