Question: show work in excel please Demand for indoor exercise bikes with online streaming classes grew significantly over the past year and is expected to continue

show work in excel please
show work in excel please Demand for indoor
Demand for indoor exercise bikes with online streaming classes grew significantly over the past year and is expected to continue to expand for the foreseeable future. Demand for bikes this past year was as follows: MONTH DEMAND (UNITS) 9,174 January February March 9,394 8,734 9,614 April May 10,934 10,274 June 11,594 10,714 11,814 July August September October November December 12,474 13,794 13,134 Copy data into Excel. 1. Using linear regression analysis, find what the forecast would have been for each month this year? 2. Calculate the MAD and MAPE for these forecast values? 3. What would your forecast be for January, February, and March of next year

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!