Linear Regression. Use Excel Spreadsheet (Copy the table below and Paste it into Excel). Demand for...

  

Transcribed Image Text:

Linear Regression. Use Excel Spreadsheet (Copy the table below and Paste it into Excel). 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: What is the Y Intercept? (Use either Excel 'intercept' function or Excel Data Analysis Tool: Regression) (Round your answer to the nearest whole number) Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand (Units) 4,110 4,200 4,020 4,420 5,020 4,650 5,320 4,920 5,420 5,620 6,320 6,020 Forecast Linear Regression. Use Excel Spreadsheet (Copy the table below and Paste it into Excel). 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: What is the Y Intercept? (Use either Excel 'intercept' function or Excel Data Analysis Tool: Regression) (Round your answer to the nearest whole number) Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand (Units) 4,110 4,200 4,020 4,420 5,020 4,650 5,320 4,920 5,420 5,620 6,320 6,020 Forecast