The monthly commercial and residential prices for natural gas (dollars per thousand cubic feet) in the United
Question:
The monthly commercial and residential prices for natural gas (dollars per thousand cubic feet) in the United States from January 2008 through May 2019 are stored in Natural Gas.
For the commercial 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 monthly multipliers. Do the multipliers support your answers in (a) and (b)?
f. Compare the results for the commercial prices and the residential prices.
Step by Step Answer:
Statistics For Managers Using Microsoft Excel
ISBN: 9780135969854
9th Edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat