Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: MONTH DEMAND (Units) FORECAST 1 4,220 2 4,320 3 4,020 4 4,420 5 5,020 6 4,720 7 5,320 8 4,920 9 5,420 10 5,720 11 6,320 12 6,020

Question 10 (3 points)

What is the Y intercept? (Use either Excel Intercept function or Excel Data Analysis Tool-Regression) (Round your answer to the nearest whole number

a)

3787

b)

3877

c)

3778

d)

192

Question 11 (3 points)

What is the slope of the line? (Use either Excel Slope function or Excel Data Analysis Tool-Regression) (Round your answer to the nearest whole number)

a)

192

b)

129

c)

291

d)

3787

What is the equation for linear regression? (Y=a+bt)

a)	Y=3877+192 t

b)	Y=3787+291 t

c)	Y=192+3787 t

d)	Y=3787+192 t

Forecast for period 16 is ________ (Round your answer to 2 decimal places) (Note: number can be slightly different)

Question 13 options:

a)

6286.67

b)

6863.59

c)

7055.90

d)

6671.28

Forecast for period 22 is ________ (Round your answer to 2 decimal places) (Note: number can be slightly different)

Question 14 options:

a)

7825.13

b)

8017.44

c)

7632.82

d)

7440.51