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 January February March Apri May June July August September October November December DEMAND (UNITS) 4,120 4.220 3,920 4.320 4,920 4,620 5.220 4,820 5.320 5,620 6.220 5.920 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7. (Do not round Intermediate calculations. Round your answers to 2 decimal places.) Forecast Month January February March April May June July August September October November December b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number.) Additional units Least Squares Regression Analysis (1) 1 (2) (3) txy (6) Y 1 600 2 4 3 9 4 16 5 25 36 6 1,550 1,500 1,500 2.400 3,100 2,600 2.900 3,800 4,500 4,000 4,900 33,350 7 600 3.100 4,500 6,000 12,000 18,600 18,200 23,200 34,200 45,000 44,000 58,800 268,200 8013 1,160.9 1,520,5 1,880.1 2.239.7 2,599.4 2.959.0 3,318.6 3,678.2 4,037.8 4,397.4 4,757.1 360,000 2,402,500 2,250,000 2,250,000 5760,000 9,610,000 6,760,000 8,410,000 14,440,000 20,250,000 16,000,000 24,010,000 112,502,500 49 64 8 81 9 10 100 121 = 12 78 144 650 T= 6.5 b = 359.6154 y = 2.779.17 a = 4416667 Therefore, Y=44167 + 359.6t 5 = 3639 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 January February March April May June July August September October November December DEMAND (UNITS) 4,120 4,220 3,920 4,320 4,920 4,620 5,220 4,820 5,320 5.620 6,220 5,920 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7 (Do not round intermediate calculations. Round your answers to 2 decimal places.) Forecast Month January February March April May June July August September October November December b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number Additional units 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 January February March Apri May June July August September October November December DEMAND (UNITS) 4,120 4.220 3,920 4.320 4,920 4,620 5.220 4,820 5.320 5,620 6.220 5.920 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7. (Do not round Intermediate calculations. Round your answers to 2 decimal places.) Forecast Month January February March April May June July August September October November December b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number.) Additional units Least Squares Regression Analysis (1) 1 (2) (3) txy (6) Y 1 600 2 4 3 9 4 16 5 25 36 6 1,550 1,500 1,500 2.400 3,100 2,600 2.900 3,800 4,500 4,000 4,900 33,350 7 600 3.100 4,500 6,000 12,000 18,600 18,200 23,200 34,200 45,000 44,000 58,800 268,200 8013 1,160.9 1,520,5 1,880.1 2.239.7 2,599.4 2.959.0 3,318.6 3,678.2 4,037.8 4,397.4 4,757.1 360,000 2,402,500 2,250,000 2,250,000 5760,000 9,610,000 6,760,000 8,410,000 14,440,000 20,250,000 16,000,000 24,010,000 112,502,500 49 64 8 81 9 10 100 121 = 12 78 144 650 T= 6.5 b = 359.6154 y = 2.779.17 a = 4416667 Therefore, Y=44167 + 359.6t 5 = 3639 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 January February March April May June July August September October November December DEMAND (UNITS) 4,120 4,220 3,920 4,320 4,920 4,620 5,220 4,820 5,320 5.620 6,220 5,920 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.7 (Do not round intermediate calculations. Round your answers to 2 decimal places.) Forecast Month January February March April May June July August September October November December b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number Additional units