Question: I need this please help 2. 1 4 00 2 9 3 5 5 13 6 18 7 12 9 9 10 11 11 7

I need this please help I need this please help 2. 1 4 00 2 9 3 5 5 13 6

2. 1 4 00 2 9 3 5 5 13 6 18 7 12 9 9 10 11 11 7 7 9 13 Year Deman d (Unit) 1. Plot the data using excel (you need to submit the excel file). Is there any type of cycle or trend or seasonality present in the data? Justify your answer. 2. Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Take the necessary weight as per your understanding. Plot the actual demand vs predicted demand. And using this plotting refine your weights, which will minimize the mean absolute error. (You need to calculate it). 3. Forecast from the month no 3 using the exponential smoothing. Take three values of the constant (high, medium, low) and evaluate+ plot your predicted values. Justify which value of the constant gives the better prediction by calculating the mean squared absolute error for each case

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!