Consider again the Sherwin-Williams Company example (see Table). Suppose one is interested in developing a multiple regression model with paint sales (Y) as the dependent variable and promotional expenditures (A) and selling price (P) as the independent variables.

a. Determine the estimated regression line.

b. Give an economic interpretation of the estimated slope (bs) coefficients.

c. Test the hypothesis (at the 5 percent level of significance) that there is no relationship between the dependent variable and each of the independent variables.

d. Determine 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 5 percent level).

f. Based on the regression model, determine the best estimate of paint sales in a sales region where promotional expenditures are $80(000) and the selling price is $12.50.

g. Determine the point promotional and price elasticities at the values of promotional expenditures and selling price given in part(f).

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