Question: Using the Excel Spreadsheet and the Forecasting in Excel article ( both attached here ) , follow the instructions ( that start on page 2

Using the Excel Spreadsheet and the Forecasting in Excel article (both attached here), follow the instructions (that start on page 215) to forecast Telehealth visits using A) both a 3- and 5- year moving average technique; B) exponential smoothing with both a .1 and .3 factor; and C) linear regression. The excel file has a separate worksheet for each of these techniques using data for Telehealth visits. Then, calculate the Mean Absolute Deviation for each method and put in the summary sheet designated for this. Which method is most accurate?

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!