1. Business
  2. Economics
  3. estimate house paints demand for sherwinwilliams table sherwinwilliams company new...

Question: estimate house paints demand for sherwinwilliams table sherwinwilliams company new...

Question details

Estimate House Paints Demand for Sherwin-Williams

Table: Sherwin-Williams Company new Data

Observations

Sales

Promotional Expenditures

Selling Price

Disposable Income

i

y

A

P

M

1

160

100

15

19

2

200

160

14

17.5

3

140

50

16.5

14

4

190

190

14.5

20

5

130

90

17

15.5

6

160

70

16

14.5

7

200

140

15

21.5

8

150

110

18

18

9

210

200

12

18.5

10

190

100

15.5

20

Total

1730

1210

153.5

178.5

Mean

173

121

15.35

17.85

1) What is regression equation for paint sales using multiple linear regression model? Please include regression results using Excel?)

2) If A=180, P=$14, and M=20, what is an approximate 95 percent prediction interval for paint sales?

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution