Question: Consider the Sherwin-Williams Company example (see Table). Suppose one is interested in developing a simple regression model with paint sales (Y) as the dependent variable

Consider the Sherwin-Williams Company example (see Table). Suppose one is interested in developing a simple regression model with paint sales (Y) as the dependent variable and selling price (P) as the independent variable.
a. Determine the estimated regression line.
b. Give an economic interpretation of the estimated intercept (a) and slope (b) coefficients.
c. Test the hypothesis (at the .05 level of significance) that there is no relationship (that is, β = 0) between the variables.
d. Calculate the coefficient of determination.
e. Perform an analysis of variance on the regression, including an F-test of the overall significance of the results (at the .05 level).
f. Based on the regression model, determine the best estimate of paint sales in a sales region where the selling price is $14.50. Construct an approximate 95 percent prediction interval.
g. Determine the price elasticity of demand at a selling price of$14.50.

Consider the Sherwin-Williams Company example (see Table). Suppo

SHERWIN-WILLIAMS COMPANY DATA SALES REGION GALLONS) SALES (Y) (x 1,000 PROMOTIONAL EXPENDITURES (A) (x$1,000) DISPOSABLE INCOME (M) (x $1,000) SELLING PRICE (P) (S/GALLON) 15.00 13.50 16.50 14.50 17.00 16.00 13.00 18.00 12.00 15.50 160 220 140 190 130 160 200 150 210 190 150 160 50 190 90 19.0 175 14.0 21.0 15.5 14.5 21.5 18.0 18.5 140 110 200 100 10

Step by Step Solution

3.32 Rating (176 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Using Excel the regression output for the Sherwin Williams data is Coefficients Standard Error t Stat Intercept 390376 442 88 price 14263 29 49 a Y 39... View full answer

blur-text-image
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)

Word file Icon

208-B-E-M-E (540).docx

120 KBs Word File

Students Have Also Explored These Related Economics Questions!