# Question: If you operate a refinery and need to buy crude

If you operate a refinery and need to buy crude oil (and haven’t made a prior arrangement that locked in a lower price), the spot price for crude oil determines what you can expect to pay per barrel (42 gallons). The data for this exercise also include the price of gasoline sold at service stations to retail customers. Both series were compiled by the Department of Energy and represent national averages. The data are weekly from January 1997 through May 2012.

Motivation

(a) The rise of gasoline prices along with record profits at Exxon-Mobile produced stories of corporate greed. How could you use a statistical model to explain the rise of prices at the pump?

Method

(b) If price increases are immediately passed on to consumers on a 1-for-1 basis, what should you expect for the slope of a simple regression of the price of gas (in dollars per gallon) on the price of crude oil (in dollars per barrel)?

(c) Do you think it will be easier to work with prices directly or with percentage changes? Use plots of the time trends in the prices and in the percent-age changes to form your answer.

(d) Price changes are unlikely to immediately move through the system. It takes a while for refined oil to reach the pump. If the effects of price changes in crude take several weeks to reach the pump, what type of transformations of crude prices can you expect to be useful in explaining the rise in prices at the pump?

Mechanics

(e) Fit the simple regression of gasoline prices on contemporaneous prices of crude oil. Is the slope near what you expected?

(f) Examine the residuals from the simple regression that you ft in part (e). Do these meet the conditions for fitting the simple regression model? In particular, what flaw common to time series regressions is evident in the residuals from this model?

(g) Fit the simple regression of the percentage change in price of gasoline on the percentage change in the price of crude oil in the same period. What does the slope of this regression tell you?

(h) Do the residuals from the simple regression in percentage changes meet the conditions for fitting the SRM?

(i) Add six lags of the percentage change in the price of crude oil to the regression ft in part (g). (The model will then have seven predictors: the current percentage change as well as the percentage changes from the prior six weeks.) Does the ft improve by adding the collection of lags? What is the interpretation of the coefficients of the lagged variables?

(j) Does collinearity have a strong effect on the ft of the multiple regression in part (i)?

(k) Are the residuals from the regression ft in (i) nearly normal? Do any stand out?

(l) Does the model you created in part (i) satisfy the conditions of the multiple regression model?

Message

(m) What does this analysis mean for being able to predict future movements in the price of gasoline based on movements in the price of crude oil?

Motivation

(a) The rise of gasoline prices along with record profits at Exxon-Mobile produced stories of corporate greed. How could you use a statistical model to explain the rise of prices at the pump?

Method

(b) If price increases are immediately passed on to consumers on a 1-for-1 basis, what should you expect for the slope of a simple regression of the price of gas (in dollars per gallon) on the price of crude oil (in dollars per barrel)?

(c) Do you think it will be easier to work with prices directly or with percentage changes? Use plots of the time trends in the prices and in the percent-age changes to form your answer.

(d) Price changes are unlikely to immediately move through the system. It takes a while for refined oil to reach the pump. If the effects of price changes in crude take several weeks to reach the pump, what type of transformations of crude prices can you expect to be useful in explaining the rise in prices at the pump?

Mechanics

(e) Fit the simple regression of gasoline prices on contemporaneous prices of crude oil. Is the slope near what you expected?

(f) Examine the residuals from the simple regression that you ft in part (e). Do these meet the conditions for fitting the simple regression model? In particular, what flaw common to time series regressions is evident in the residuals from this model?

(g) Fit the simple regression of the percentage change in price of gasoline on the percentage change in the price of crude oil in the same period. What does the slope of this regression tell you?

(h) Do the residuals from the simple regression in percentage changes meet the conditions for fitting the SRM?

(i) Add six lags of the percentage change in the price of crude oil to the regression ft in part (g). (The model will then have seven predictors: the current percentage change as well as the percentage changes from the prior six weeks.) Does the ft improve by adding the collection of lags? What is the interpretation of the coefficients of the lagged variables?

(j) Does collinearity have a strong effect on the ft of the multiple regression in part (i)?

(k) Are the residuals from the regression ft in (i) nearly normal? Do any stand out?

(l) Does the model you created in part (i) satisfy the conditions of the multiple regression model?

Message

(m) What does this analysis mean for being able to predict future movements in the price of gasoline based on movements in the price of crude oil?

## Answer to relevant Questions

1. Zip codes are an example of numerical data. 2. Quantitative data consist of numbers along with their units. 3. Cases is another name for the columns in a data table. 4. The number of rows in a data table is indicated by ...A supermarket mailed 4,000 uniquely identifiable coupons to homes in local residential communities. Each day of the next week, it counted the number of coupons that were redeemed and the size of the purchase. (a) Identity ...Motivation (a) If you were able to reduce the cost of the books that you buy each year by 5 or 10%, how much do you think you might be able to save in a year? Method (b) Create a data table of prices for the three types of ...The following table summarizes findings from a study done by Apple concerning working conditions in factories operated by its suppliers.9 Under pressure from consumers concerned about working conditions in China, Apple ...These data summarize the market share for artificial sweeteners held by the major brands in 2002 and 2005. Prepare a chart that shows the shares each year and the brands that gained the most share from 2002 to 2005.Post your question