Question: Order Size and Shipping Cost (n = 12) (a) Use Excel's Data Analysis > Regression (or MegaStat or MINITAB) to obtain regression estimates. (b) Interpret

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.

Orders 0X) Ship Cost (Y) 1,068 1,026 767 885 1,156 1,146 892 938 769 677 1,174 1,009 4,489 5,611 3,290 4,113 4,883 5,425 4,414 5,506 3,346 3,673 6,542 5,088

Step by Step Solution

★★★★★

3.48 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a MegaStat regression output Regression Analysis r 0672 n 12 r 0820 k 1 Std Error 599029 Dep Var Shi... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

485-M-S-L-R (3530).docx

120 KBs Word File

Students Have Also Explored These Related Statistics Questions!

Order Size and Shipping Cost (n = 12) (a) Use Excel to make a scatter plot of the data. (b) Select the data points, right-click, select Add Trendline, select the Options tab, and choose Display...

(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...

Find the 95 percent confidence interval for the population variance from these samples. a. n = 15 commuters, s = 10 miles driven b. n = 18 students, s = 12 study hours

Recall from Exercise 14.32 (page 616) that Enterprise Industries has advertised Fresh liquid laundry detergent by using three different advertising campaigns-advertising campaign A (television...

Recall from Exercise 14.5 that Enterprise Industries has observed the historical data in Table 14.5 concerning y (demand for Fresh liquid laundry detergent), x1 (the price of Fresh), x2 (the average...

Recall from Exercise 14.6 that Enterprise Industries has observed the historical data in Table 14.6 concerning y (demand for Fresh liquid laundry detergent), x1 (the price of Fresh), x2 (the average...

(a) Use Excel?s Data page 470 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)...

The following partial Excel add-in (MegaStat) regression output for the direct labor cost data relates to predicting direct labor cost when the batch size is 60. a. Report (as shown on the computer...

Enterprise Industries produces Fresh, a brand of liquid laundry detergent. In order to manage its inventory more effectively and make revenue projections, the company would like to better predict...

Refer to the Amazon.com, Inc., consolidated financial statements in Appendix A at the end of this book. The cash and cash equivalents section of the Consolidated Balance Sheet shows a balance of...

Identify the method of heat transfer that takes place in each illustration. Some illustrations may show more than one form of heat transfer. SSSS 3. O0000 4. 6. 7. 8. 9. 5.

Explain why it is important for an eco- nomic model to be an abstraction from the real world.

What is the relationship between present value, future value, and the interest rate in the case of a perpetuity?

This histogram shows the average annual premium (in dollars) for homeowners insurance paid in the 50 states and District of Columbia.19 (a) Which holds more states, the interval from $600 to $700 or...

The following histogram and boxplot summarize the distribution of income for 1,000 households in Colorado. (a) Estimate the mean and median. How do you know that the mean is larger than the median...

The following display summarizes the percentage of household income that goes to rent for 1,000 families that live in Denver, Colorado. (a) Estimate the mean and median from the fgure. (b) Estimate...

Suppose X1, ..., Xn are iid random vectors from No(u, E) with E being known and positive definite. Our interest is to make inference on the unknown vector /. Suppose our interest is to test Ho : M =...

Please help me with this statistics problem. I don't know how to answer it. 1. (30 points) Let Yl, ..., Yn be i.i.d. samples from the density function kyk-1 fo(y) = Ak 10 2 is a positive integer. (a)...

Caterpillar, Inc CNH Global 2014 2013 2012 2013 Profit Margin 7.09% 7.19% 9.01% 8.22% I have performed DuPont analysis on Caterpillar Inc. and its closest competitor, CNH Global. Your analysis should...