Share
Explore BrainMass

# Regression analysis in Minitab

See attached file.

The Zebra Wild Game Company sells exotic game to high end restaurants throughout Asia. The sales manager wants to determine what, if any, relationship exists between the pounds/week of game sold by 24 sales persons and the advertising dollars spent (in hundreds of dollars/week).

Attached is the Minitab regression output. The dependent variable is Sales (in pounds/week) and the independent variable is Advertising (in hundreds of dollars/week)

Using the Minitab output, write the regression equation, and explain each of the regression coefficients.

Regression Equation: y = [ ] + [ ]x
*Round answer to three decimal places

Interpretation of bo:
A. This tells us the average advertising dollars spent (in hundreds of dollars/week).
B. This tells us the average number of pounds/week of game sold by the sales force.
C. This says we are 95% confident that in the population each additional advertising dollar spent (in hundreds of dollars/week) will result in an increase in sales of game sold around this value.
D. This tells us the estimated level of sales when the advertising expenditure = \$0.
E. This says we are 95% confident that in the population each additional \$1,000 in sales will result in an increase of this amount of advertising (in hundreds of dollars/week)

Interpretation of b1:
A. This tells us that for each additional advertising dollar spent (in hundreds of dollars/week), we can expect a decrease of 30.023 pounds/weel of game sold.
B. This tells us that for one advertising dollar spent (in hundreds/week), one can expect that 203.835 pounds of game will be sold.
C. This is the estimate of the pounds/week of game that will be sold without any advertising dollars spent (in hundreds of dollars/week)
D. This tells us that for each additional \$100 per week spent on advertising, we can expect an increase of 30.023 pounds/week of game sold.
E. This value has no practical interpretation.

#### Solution Summary

Step by step method for computing regression equation is given in the answer.

\$2.19