Question: data below with excel: cannot insert the file so i took a picture of the data that go with the problems also listed below.1. Use

data below with excel: cannot insert the file so i took a picture of the data that go with the problems also listed below.1. Use the Native method to forecast the price of this stock for the next trading day. Use two decimals.Forecast for period 22:_________________How well does this method forecast the known observations in this series? Calculate the Mean Absolute Percent Error (MAPE):_______________2. Use the cumulative mean method to forecast the price of this stock for the next trading day.Forecast for period 22:__________How well does this method forecast the known observations in this series? Calculate the Mean Absolute Percent Error (MAPE):__________3.Using the moving average method with N = 5 to forecast the price of this stock for the next trading dayForecast for period 22:_____________How well does this method forecast the known observations in this series? Calculate the Mean Absolute Percent Error (MAPE):____________4. Use the exponential smoothing method with ALPHA = 0.3 to forecast the price of this stock for the next trading dayForecast for period 22:__________How well does this method forecast the known observations in this series? Calculate the Mean Absolute Percent Error (MAPE):____________5. What forecasting method would you use for this data based on the MAPE?a) Naiveb) Moving averages with N = 3c) Exponential Smoothing with alpha 0.30d) Cumulative Mean

data below with excel: cannot insert the file so i took a

\f

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 Mathematics Questions!