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
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
