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

\f
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
