Question: Objective: Forecast milk prices using Moving Average and Exponential Smoothing methods to analyze trends in agricultural pricing. Instructions 1 . Data Source: Download historical monthly
Objective: Forecast milk prices using Moving Average and Exponential Smoothing methods to analyze trends in agricultural pricing.
Instructions
Data Source:
Download historical monthly milk prices from any appropriate series
available at the US Department of Agriculture USDA Milk Cost
of Production Estimates.
Ensure the dataset spans at least ten years to capture meaningful
trends.
Data Preparation:
Convert the date column to a datetime format and set it as the index.
If necessary, clean the data by filling missing values using forward or
backward fill methods.
Exploratory Data Analysis EDA:
Plot the milk price time series to observe trends, seasonality, or irregularities.
Describe the main patterns in one or two sentences.
Moving Average Forecasting:
Apply a Moving Average model with window sizes of and
months.
Plot the original series and the smoothed series for each window size.
Briefly discuss the effectiveness of each window size for trend detection.
Exponential Smoothing Forecasting:
Apply Single Exponential Smoothing and Double Exponential Smoothing
methods.
Plot the forecasts on the same graph as the original series.
Compare the methods and note which is more responsive to recent
price changes.
Evaluation:
Calculate the Mean Absolute Error MAE or Mean Squared Error
MSE for each forecasting method.
Summarize your findings on the most effective technique for this
dataset.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
