Question: PLZ DO a-g. Please explain all your steps and excel formals. really want to learn the material so the more detailed the better. Thank you

PLZ DO a-g. Please explain all your steps and excel formals. really want to learn the material so the more detailed the better. Thank you so much
Problem 1 (15 points) Apex Mutual Fund invests primarily in technology stocks. The price of the fund at the end of each month for the 12 months of 2019 is shown in Table below. a. Find the forecast value of the mutual fund for each month by using a nave model. The value for December 2018 was 19.00. b. Evaluate this forecasting method using the MAD. C. Evaluate this forecasting method using the RMSE. d. Evaluate this forecasting method using the MAPE. e. Using a naive model, forecast the mutual fund price for January 2020. f. Use a three-month moving average to forecast the mutual fund price for January 2020. Is this forecast better than the forecast made using naive model? Explain. g. Use a four-month weighted moving average to forecast the mutual fund price for January 2020. Is this forecast better than the forecast made using three- month moving average? Explain. Month January February March April May June July August September October November December Mutual 19.39 18.96 18.20 17.89 18.43 19.98 19.51 20.63 19.78 21.25 21.18 22.14Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
