125% Zoom fx v Formula ? Tips 14 Format Sort & Filter View Table Chart Text Shape Media Comment Share + Prob Set 1 Prob Set 2 Prob Set 3 Prob Set 4 Prob Set 5 Prob Set 6 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 joggers from wearing them. Demand for the players for last year was as follows. Using linear regression technique, what would you estimate demand to be for each month next year? (Using Excel regression tools) https://www.excel- Next Year (Month) Forecast t (Month) 1 2 3 Intercept(a): Slope(b): Use MS-Excel regress ToolPak that is acces options by using the Y=a + bt 4 For PC user - MS-Exc 5 y (Actual Demand) 4100 4500 4500 4800 5200 4900 5500 4800 5200 5900 6500 6300 6 7 8 9 10 11 12 For Mac user - MS-Ex