The monthly wellhead and residential prices for natural gas (dollars per thousand cubic feet) in the United

Question:

The monthly wellhead and residential prices for natural gas (dollars per thousand cubic feet) in the United States from January 2008 through June 2012 are stored in Natural Gas2. (Data extracted from Energy Information Administration, U.S. Department of Energy, www.eia.gov, Natural Gas Monthly, August 3, 2012.)
For the wellhead price and the residential price,
a. Do you think the price for natural gas has a seasonal component?
b. Plot the time series. Does this chart support your answer in (a)?
c. Compute an exponential trend forecasting equation for monthly data.
d. Interpret the monthly compound growth rate.
e. interpret the month multipliers. Do the multipliers support your answers in (a) and (b)?
f. compare the results for the wellhead prices and the residential prices.
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Statistics For Managers Using Microsoft Excel

ISBN: 772

7th Edition

Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat

Question Posted: