Question: Linear Regression. Use Excel Spreadsheet (Copy the table below and Paste it into Excel). Demand for stereo headphones and MP3 players for joggers has
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
