Question

NARRBEGIN: SA_76_78
The owner of a pizza restaurant chain would like to predict the sales of her specialty, the deep-dish Mexican pizza. She has gathered data on monthly sales of the deep-dish Mexican pizza at her restaurants. She has also gathered information related to the average price of the deep-dish pizzas, the monthly advertising expenditures and the disposable income per household in the areas surrounding the restaurants. Below you will find output from the stepwise regression analysis. The p-value method was used with a cutoff of 0.05.
Summary measures
Multiple R 0.9513
R-Square 0.9049
Adj R-Square 0.8990
StErr of Estimate3924.53
Regression coefficients
CoefficientStd Errt-valuep-value
Constant-45233.648914.72-5.07400.0001
Monthly Adv. Expenditures1.9720.16012.34050.0000

NARREND
(A) Summarize the findings of the stepwise regression method using this cutoff value.
(B) When the cutoff value was increased to 0.10, the output below was the result. The table at top left represents the change when the disposable income variable is added to the model and the table at top right represents the average price variable being added. The regression model with both added variables is shown in the bottom table. Summarize the results for this model.
Disposable income variable being added
Summary measures
% Change
Multiple R0.96081.00%
R-Square0.92322.00%
Adj R-Square0.9131.60%
StErr of Estimate3643.11-7.20%
Average price variable being added
Summary measures
% Change
Multiple R0.97231.20%
R-Square0.94542.40%
Adj R-Square0.93372.30%
StErr of Estimate3179.03-12.70%
Regression coefficients

CoefficientStd Errt-valuep-value
Constant-73971.5323803.23-3.10760.0077
Monthly Adv. Expenditures0.9520.3752.53870.0236
Disposable Income2.6060.9772.66590.0184
Average Price-2056.27861.342-2.38730.0316
(C) Which model would you recommend using? Why?

Answer

This answer is hidden. It contains 1047 characters.