Obtain a time-series plot and correlogram

Assignment Help Applied Statistics
Reference no: EM13144696

Natural Gas Spot and Future Prices

The law of one price implies that the spot price and the future price of a commodity should not deviate too far away from each other when the net cost of carrying is accounted for. The main driver for such a stable relationship is opportunities of arbitrage. If the two prices become significantly different from each other, market participants take opportunity of arbitrage, driving their levels back to the parity. In other words, arbitrage opportunities prevent the two prices from deviating too far away from each other. Such an equilibrium relationship between the spot and future prices of a commodity is represented by the spot-future parity condition:

Ft = Stert

where F = future price,
S = spot price, and
r = net cost of carrying.

Taking the log of both sides of (A) and adding a term representing random noises leads to the following regression model.

lnFt = β1 + β2lnSt + β3rt + ut

Note that for spot-future parity to hold, β1 = 0, β2 = β3 = 1.

For the present exercise, we consider the relationship between the spot and future prices of natural gas.

Data (Monthly)

The monthly observations on prices are obtained from the U.S. federal government's Energy Information Administration website, and the data on interest rate (as net cost of carrying) are obtained from the Federal Reserve's website.

The variables are defined as follows:

Ft = future price of natural gas in $US per million Btu1 for the delivery in the following month,

St = spot price in $US per million Btu, and
rt = one-month bank bill rate (% per year).

Generate lnF and lnS after importing the data into Gretl.

Questions

Use the variables: lnF, lnS and r.

(1) Obtain a time-series plot and correlogram for each variable, and comment on them with regard to the stationarity/non-stationarity property of the variable.

(2) Test, at 10%, for unit root on both the level (Yt) and the first-difference (ΔYt) of each variable (and the second difference, Δ2
Yt, if necessary) to determine the order of integration.

Use the Augmented Dickey-Fuller test with constant (τc), and let the optimum number of lags in the test equation be determined by "modified AIC". In Gretl, leave the (maximum) lag order at the default level (14) and select "test down from the maximum lag order".

A preliminary analysis reveals that the net cost of carrying (r) is not that important in the parity condition, (A). Ignore it for the remaining questions.

Q(3)-Q(6): Consider the model in first differences.

Δ lnFt = β1 + β2Δ lnSt + ut (C)

(3) Estimate (C) by the OLS method. Then, test for heteroscedasticity and fourth-order autocorrelation at the 5% significance level. (Use the Koenker version of the Breusch-Pagan test for heteroscedasticity and the Breusch-Godfrey test for autocorrelation. Use the N×R2 statistic in both cases.)

(4) Provide a summary report of the OLS estimation of (C), taking into account the test results in (3).

(5) Assume that the log of the variance function of ut is given by

lnσt2 =  α0 + α1u2t-1

where ^ut are OLS residuals. Estimate (C) by the FGLS (WLS) method and report the estimation result.

(6) Estimate (C) by the Cochrane-Orcutt method (with the Paris-Winsten transformation) correcting for first-order autocorrelation. Provide a summary report of the result. (Use Model > Time series > AR(1) in Gretl.)

(7) Using the Engle-Granger residual-based method, test at 10% if the following is a cointegrating relationship.

lnFt = βlnSt + ut (E)

where ut are random errors.

In Gretl, leave the (maximum) lag order at the default level (12) and select "test down from maximum lag order" so that the optimum number of lags in the test equation is automatically determined from 0-12. Note that (E) does not have a constant term (i.e., intercept).

(8) Discuss the implications of the test results from (3) and (7) for the estimation results reported in (4).

(9) Estimate the following error correction model by the OLS method and provide a summary report of the estimated equation.

Δ lnFt = β0 + αut-1 + β1ΔlnFt-1 + β2Δ lnSt-1 + vt (F)

where ΔYt = Yt - Yt-1 and ^ut are the OLS residuals from (E). α and β are the regression coefficients.

(10) Obtain a time-series plot and correlogram of the residuals from (9) and comment on them with regard to the violation of classical assumptions. Test for fourth-order autocorrelation using the Breusch-Godfrey (N×R2) procedure.

Download:- data.xlsx

Reference no: EM13144696

Questions Cloud

Investigating sampling distribution of the mean : Ssample by constructing a histogram and finding the sample mean and standard deviation, are we investigating the sampling distribution of the mean? why or why not?
What is the appearance of the f1 generation : Suppose a homozygous short, green, wrinkled pea planti is crossed with a homozygous tall, yellow, smooth plant.
Accounting treatments for parent and subsidiary : Explain the general rules and accounting treatments for the parent and subsidiary, including purchase price allocations; intangible assets, such as goodwill and impairment testing; intercompany transactions
What types of individuals occur at the two ends of the curve : CritIcal Thinking - Are the genes of individuals who don't reproduce included in the gene pool. Explain your answer.
Obtain a time-series plot and correlogram : Obtain a time-series plot and correlogram of the residuals from (9) and comment on them with regard to the violation of classical assumptions. Test for fourth-order autocorrelation using the Breusch-Godfrey procedure
Calculate the gain or loss on retirement : Assume that the bonds are called on December 31, 2009. Use the horizontal model (or write the journal entry) to show the effect of the retirement of the bonds. (Hint: calculate the amount paid to bondholders; then determine how much of the bond di..
Operating cash flow of abc company : The operating expenses including depreciation expense of $200,000. ABC company pays tax at a rate of 30%. All sales and purchases are in cash. Calculate the operating cash flow of ABC company
A student is presented with a sample of an unknown substance : A student is presented with a sample of an unknown substance and asked to classify the substance as organic or inorganic
What are the components of a species ecological niche : what are the components of a species ecological niche in relation to primate behavioral ecology?

Reviews

Write a Review

Applied Statistics Questions & Answers

  Create a histogram for iq and include normal distribution

Use Analyze, Descriptive statistics, Frequencies to summarize nonmetric variables, and create a pie-chart for Year in college and create a histogram for IQ and include the normal distribution.

  Evaluate the probability the sample mean

What can we say about the shape of the distribution of the sample mean?

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Evaluate the correlation coefficient

Evaluate the correlation coefficient.

  Define the hypothesis and find the standard error

Define the hypothesis and find the standard error of the difference in the means also find the test statistic - Determine the required sample size to be able to use a 99% confidence interval.

  Calculating a z-score and graphing a box plot

Calculating a Z-score and graphing a box plot and Statistical Inference of Sample Mean , Binomial Distribution and Regression Analysis

  Measures of central tendency and dispersion with spss

Generate syntax and output files in SPSS. You will need to copy and paste these into your Application document. Use one kind of chart (any kind) to describe the data

  What is the overall accuracy of the test

A screening test for a newly discovered disease is being evaluated. In order to determine the effectiveness of the new test, it was administered to 900 workers; 150 of the individuals diagnosed with the disease tested positive.

  Quantitative analysis

What is the probability of winning a prize in an office sweep

  What is the null hypothesis

Is the mean Hemoglobin level of a group of high-altitude workers different from 16g/cc and does the mean speed of 50 cars as checked by radar on a I-70 differ from 65mph?

  What research design was used this study

What research design was used this study

  Calculate the regression equation

Calculate the regression equation for this data

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd