B D E H K L M A 1 Problem Set 5 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 2 joggers from wearing them. Demand for the players for last year was as follows. 3 Using linear regression technique, what would you estimate demand to be for each month next year? (Using Excel regression tools) 4 Forecast y (Actual Demand) Next Year (Month) 4100 5 6 7 8 9 10 11 t (Month) 1 2 3 4 Intercept(a): Slope(b): Y;=a + bt 5 6 7 8 9 12 13 14 15 16 17 18 19 4500 4500 4800 5200 4900 5500 4800 5200 5900 6500 6300 10 11 12 B D E H K L M A 1 Problem Set 5 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 2 joggers from wearing them. Demand for the players for last year was as follows. 3 Using linear regression technique, what would you estimate demand to be for each month next year? (Using Excel regression tools) 4 Forecast y (Actual Demand) Next Year (Month) 4100 5 6 7 8 9 10 11 t (Month) 1 2 3 4 Intercept(a): Slope(b): Y;=a + bt 5 6 7 8 9 12 13 14 15 16 17 18 19 4500 4500 4800 5200 4900 5500 4800 5200 5900 6500 6300 10 11 12