Question: Given real - world data for weekly Texas regular conventional retail gasoline prices ( in Dollars per Gallon ) , sourced from the U .
Given realworld data for weekly Texas regular conventional retail gasoline prices in Dollars
per Gallon sourced from the US Energy Information Administration, please make
predictions for the retail price of regular gasoline disclosed in the week following next week
Sourcekey EMMEPMRUPTESTXDPG
Date Weekly Texas Regular Conventional Retail Gasoline Prices Dollars per Gallon
Jan
Jan
Jan
Jan
Jan
Feb
Feb
Feb
Feb
Mar
Mar
Mar
Mar
Apr
Apr
Apr
Apr
May
May
May
May
May
Jun
Jun
Jun
Jun
Jul
Jul
Jul
Jul
Jul
Aug
Aug
Aug
Aug
Sep
Sep
Sep
Sep
Oct
Oct
Oct
Oct
Oct
Nov
Nov
Nov
Nov
Dec
Dec
Dec
Dec
Jan
Jan
Jan
Jan
Jan
Feb
Feb
Feb
Feb
Mar
Mar
Mar The price you are required to predict. Weighted Moving Average Method: The length of the time window and the weights
assigned to each data point should be thoughtfully selected through your analysis, for
example, using trial and error. Please provide a brief explanation of your selections, along
with a detailed analysis and calculation process. points
Exponential Smoothing Method: Choose an appropriate through your understanding
or analysis, like trial and error. Explain your selection and provide a detailed analysis and
calculation process. points
Linear Regression Method: Provide a detailed analysis and calculation process. Note that
the entire timeseries data is NOT LINEAR, so its highly recommended to use a portion
of the data for forecasting. points
Forecasting Accuracy: No action is required for this question. Your score will be based
on the accuracy of your best forecast from one of the three methods above compared to
the actual price of regular gasoline in Texas for the week after next week. The actual
price for your predictions will be disclosed on points
Tips:
a You can choose to use part eg the most recent data of the given data in your
predictions. If you decide to do this, please give a brief explanation of it
b You can use mean absolute percent error MAPE or mean absolute deviation MAD to
measure your forecast errors, then decide the required parameters in each forecasting
model.
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
