Question

. Using only the New York sales data:

1a. Forecast sales for January 5^th through January 30^th using exponential smoothing with alpha set to 0.6. Assume the sales forecast for January 4^th was 456.

1b. Using your forecasts from 1a, find the mean absolute deviation of the sales forecasts for January 5^th through January 29^th. Again, you should not include the forecast for January 30 since there is no corresponding sales figure for that date.

1c. Using your forecasts from 1a, find the mean squared error of the sales forecasts for January 5^th through January 29^th.

Date				New York
1/4/18				456
1/5/18				650
1/6/18				543
1/7/18				632
1/8/18				546
1/9/18				531
1/10/18				544
1/11/18				639
1/12/18				570
1/13/18				544
1/14/18				674
1/15/18				711
1/16/18				594
1/17/18				564
1/18/18				693
1/19/18				645
1/20/18				570
1/21/18				456
1/22/18				609
1/23/18				585
1/24/18				609
1/25/18				480
1/26/18				544
1/27/18				560
1/28/18				476
1/29/18				656
1/30/18

Answer 1

Below is the screenshot of the formula applied -

Below is the screenshot of the result obtained -