# Question

Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semi fragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P10_28.xlsx.

a. Estimate an appropriate multiple regression equation to predict the cost of shipping a given package.

b. Interpret the estimated regression coefficients. You should find that the estimated intercept and slope of the equation are sample means. Which sample means are they?

c. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship?

d. How well does the estimated equation fit the given sample data? How do you think the model’s goodness of fit could be improved?

e. Given the estimated regression equation, predict the cost of shipping a package with semi fragile cargo.

a. Estimate an appropriate multiple regression equation to predict the cost of shipping a given package.

b. Interpret the estimated regression coefficients. You should find that the estimated intercept and slope of the equation are sample means. Which sample means are they?

c. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship?

d. How well does the estimated equation fit the given sample data? How do you think the model’s goodness of fit could be improved?

e. Given the estimated regression equation, predict the cost of shipping a package with semi fragile cargo.

## Answer to relevant Questions

The file P10_11.xlsx contains annual observations (in column B) of the American minimum wage. The basic question here is whether the minimum wage has been growing at roughly a constant rate over this period. a. Create a time ...Does the rate of violent crime acts vary across different regions of the United States? Answer this with the (somewhat old), 1999 data in the file P10_34.xlsx as requested below.a. Estimate an appropriate regression model to ...Management of a home appliance store would like to understand the growth pattern of the monthly sales of Blu-ray disc players over the past two years. Managers have recorded the relevant data in the file P10_09.xlsx.a. ...The file P10_49.xlsx contains the amount of money spent advertising a product and the number of units sold for eight months.a. Assume that the only factor influencing monthly sales is advertising. Fit the following three ...The file P02_35.xlsx contains data from a survey of 500 randomly selected households. For this problem, use Monthly Payment as the dependent variable in several regressions, as explained below. a. Beginning with Family Size, ...Post your question

0