With the dataset on orange juice prices from September and October, address the following tasks (data points
Question:
With the dataset on orange juice prices from September and October, address the following tasks (data points are considered to be daily): a) What would be a prudent forecasting time frame based on the given data? Sup- port your answer. b) Calculate 2-period, 3-period, and 5-period moving averages to estimate the futures price on November 1. Deliver the forecast, the MSE, and the MAPE for each of the three methods. c) Use a three-period weighted moving average model with an increasing weight scale of 1, 2, and 4 for the past periods to forecast the November 1 price. Document the forecast, the MSE, and the MAPE.
Orange juice prices are below:
Date Price 9/1/2023 327.35 9/5/2023 332.15 9/6/2023 346.15 9/7/2023 350.95 9/8/2023 349.6 9/11/2023 343.45 9/12/2023 331.5 9/13/2023 325.7 9/14/2023 331.2 9/15/2023 331.25 9/18/2023 339.05 9/19/2023 340 9/20/2023 343.4 9/21/2023 340.55 9/22/2023 341.6 9/25/2023 339.4 9/26/2023 349.4 9/27/2023 355.1 9/28/2023 345.8 9/29/2023 349.75 10/2/2023 354.8 10/3/2023 356.2 10/4/2023 365.95 10/5/2023 375.95 10/6/2023 377.2 10/9/2023 375.65 10/10/2023 381.15 10/11/2023 378.05 10/12/2023 385.25 10/13/2023 385.9 10/16/2023 382.7 10/17/2023 384.9 10/18/2023 379.85 10/19/2023 385.35 10/20/2023 391.2 10/23/2023 389.05 10/24/2023 390.8 10/25/2023 393.45 10/26/2023 396.85 10/27/2023 401.95 10/30/2023 411.95 10/31/2023 417.7