290 likes | 445 Views
Forecasting Gas Prices. Rory Hofstatter Shu -He Lin Chia -Jung Liu Claudia Muyle Sooyeon Shin Adam Sutton. INTRODUCTION. Gas prices and common commodity pricing Gas prices peaked at $4.00 per gallon in 2008 Recession and gas prices. DATA COLLECTION RAW DATA.
E N D
Forecasting Gas Prices Rory HofstatterShu-He Lin Chia-Jung Liu Claudia Muyle Sooyeon Shin Adam Sutton
INTRODUCTION • Gas prices and common commodity pricing • Gas prices peaked at $4.00 per gallon in 2008 • Recession and gas prices
DATA COLLECTIONRAW DATA • Weekly Regular Gas Prices • August 1990 – May 2010 • 1026 Observations • Data obtained from FRED
DATA VERIFICATIONRAW DATA Random Walk – Needs to be Pre-Whitened
DATA VERIFICATIONRAW DATA Descriptive Statistics – Histogram (Multi-Peaked and Positively Skewed)
DATA VERIFICATIONRAW DATA Descriptive Statistics – Correlogram Slow decay in ACF and a large spike at lag 1 in PACF
DATA VERIFICATIONRAW DATA Unit Root Test
DATA VERIFICATIONDATA TRANSFORMATION Raw Data Logarithmic Transformation Seasonal Difference First Difference of the Seasonal Difference of Log Price (DSLNPRICEPGAL)
DATA VERIFICATIONDSLNPRICEPGAL Descriptive Statistics –Line Graph
DATA VERIFICATIONDSLNPRICEPGAL Descriptive Statistics – Histogram
DATA VERIFICATIONDSLNPRICEPGAL Descriptive Statistics – Correlogram
DATA VERIFICATIONDSLNPRICEPGAL Unit Root Test
MODEL SPECIFICATION ARMA (1,1) –Estimation Output
MODEL SPECIFICATION ARMA (1,1) – Correlogram of Residuals Some Structure Still Remaining
MODEL SPECIFICATION ARMA (1,2) –Estimation Output
MODEL SPECIFICATION ARMA (1,2) – Correlogram Most of the structure now removed but some still remaining
MODEL SPECIFICATION • More Models Tried: • ARMA (1,3) • ARMA (1,4) • ARMA (2,4) • ARMA (2,5) • Best Fitting Model: ARMA (2,5)
MODEL SPECIFICATION ARMA (2,5) –Estimation Output
MODEL SPECIFICATION ARMA (2,5) – Actual, Fitted, Residual Graph
MODEL SPECIFICATION ARMA (2,5) – Correlogram
MODEL VERIFICATION To test the accuracy of the forecasting model, compare forecasted with Actual for last 26 weeks
FORECASTING Forecast for 26 weeks into the future difference
FORECASTING Forecast for 26 weeks into the future difference Zoomed
FORECASTING Recoloring the Forecast: Workfile Window: Sample: 1026 1026 Workfile Window: GENR: slnpricepgalf = slnpricepgal Workfile Window: Sample: 1 1052 Workfile Window: GENR: slnpricepgalf = slnpricepgal(-1) + dslnpricepgalf Workfile Window: Sample: 1 1052 Workfile Window: GENR: lnpricepgalf = lnpricepgal(-52) + slnpricepgalf Workfile Window: GENR: pricepgalf = exp(lnpricepgalf) Workfile Window: GENR: ppgsef = exp(fdslnsef)
FORECASTING Forecast for 26 weeks into the future – gas price per gallon
FORECASTING Forecast for 26 weeks into the future – gas price per gallon (Zoomed)
CONCLUSION • Regular gas price is predicted to stay stable around $2.80 per gallon for the next 16 weeks then drop down in price to approximately $2.20 per gallon.