Question: Could you please do G-E For G can you please enter the formula inputs so I can follow along. Thank you Problem 1 (15 points)

Could you please do G-E
For G can you please enter the formula inputs so I can follow along. Thank you
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
