Question
Suppose the Sherwin-Williams Company has developed the following multiple regression model, with paint sales Y (x 1,000 gallons) as the dependent variable and promotional expenditures
Suppose the Sherwin-Williams Company has developed the following multiple regression model, with paint sales Y (x 1,000 gallons) as the dependent variable and promotional expenditures A (x $1,000) and selling price P (dollars per gallon) as the independent variables.Y=+aA+pP+Y=+aA+pP+Now suppose that the estimate of the model produces following results: =344.585=344.585, ba=0.102ba=0.102, bp=13.397bp=13.397, sba=0.155sba=0.155, sbp=4.487sbp=4.487, R2=0.813R2=0.813, and F-statistic=11.361F-statistic=11.361. Note that the sample consists of 10 observations.
According to the estimated model, holding all else constant, a $1,000 increase in promotional expenditures sales by approximately gallons. Similarly, a $1 increase in the selling price sales by approximately gallons.
Which of the independent variables (if any) appears to be statistically significant (at the 0.05 level) in explaining paint sales?Check all that apply.
Selling price (P)
Promotional expenditures (A)
What proportion of the total variation in sales is explained by the regression equation?
0.813
0.155
0.102
The given F-value shows that you reject the null hypothesis that neither one of the independent variables explain a significant (at the 0.05 level) proportion of the variation in income.
Based on the regression model, what is the best estimate of paint sales (x 1,000 gallons) in a sales region where promotional expenditures are $90,000and the selling price is $12.50?
186.302
211.752
167.942
When promotional expenditures are $80,000 and the selling price is $12.50, the point price elasticity is , and the point promotional price elasticity is .
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started