Question: this is the question please do the steps in this format: 1. A electronic store wants to forecast its weekly sales. Historical data (in dollars)

this is the question this is the question please do the steps in this
please do the steps in this format:
this is the question please do the steps in this
this is the question please do the steps in this
this is the question please do the steps in this
1. A electronic store wants to forecast its weekly sales. Historical data (in dollars) for fifteen weeks are shown below and can be found in the Excel worksheet Excel. 1. Use data to answer the following questions: Excel 1. a) Plot the data and provide insights about the time series. b) What is the forecast for week 16 , using a 2 (3)-period moving average? c) Which one is the best model? d) Find the best exponential smoothing model by evaluating the MSE for from 0.1 to 0.9 in increments of 0.1. e) Find the optimal for MSE, MDA and MAPE Exponential Smoothing Foreoasting Enter data only in yellov cells. Finding optimal Alpha

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!