# Question: Order Size and Shipping Cost n 12 a Use Excel s

Order Size and Shipping Cost (n = 12)

(a) Use Excel's Data Analysis > Regression (or MegaStat or MINITAB) to obtain regression estimates.

(b) Interpret the 95 percent confidence interval for the slope. Does it contain zero?

(c) Interpret the t test for the slope and its p-value.

(d) Interpret the F statistic.

(e) Verify that the p-value for F is the same as for the slope's t statistic, and show that t2 = F.

(f) Describe the t of the regression.

(a) Use Excel's Data Analysis > Regression (or MegaStat or MINITAB) to obtain regression estimates.

(b) Interpret the 95 percent confidence interval for the slope. Does it contain zero?

(c) Interpret the t test for the slope and its p-value.

(d) Interpret the F statistic.

(e) Verify that the p-value for F is the same as for the slope's t statistic, and show that t2 = F.

(f) Describe the t of the regression.

**View Solution:**## Answer to relevant Questions

Refer to the Weekly Earnings data set below. (a) Use MegaStat or MINITAB to find confidence and prediction intervals for Y using the following set of x values: 12, 17, 21, 25, and 30. (b) Report the 95 percent confidence ...An estimated regression for a random sample of vehicles is MPG = 49.22 – 0.081 Horse- power, where MPG is miles per gallon and Horsepower is the engine's horsepower. The standard error is se = 2.03. Suppose an engine has ...(a) Does the 95 percent confidence interval for the slope include zero? If so, what does this tell you? If not, what does it mean? (b) Do a two-tailed t test for zero slope at α = .05. State the hypotheses, degrees of ...In a study of stock prices from 1970 to 1994, the correlation between Nasdaq closing prices on successive days (i.e., with a 1-day lag) was r = .13 with a t statistic of 5.47. Interpret this result. Consider the following prices and accuracy ratings for 27 stereo speakers. (a) Make a scatter plot of accuracy rating as a function of price. (b) Calculate the correlation coefficient. At α = .05, does the correlation ...Post your question