the department of energy websi

the department of energy website contains information aboutmonthly wholesale and retail prices for natural gas in each state.go to and then click on thelink monthly wholesale and retail prices. Under area, choose astate of interest to you, make sure the period Is monthly, and thenunder residential price click on view history. A window will openwith a time plot covering approximately a 25-year period, alongwith a table of the monthly residential prices for each year.

(a) If you have access to statistical software, you should usethe downland data (xls file) link to save the data as an excel(.xsl) file on your computer. Then enter the data into yoursoftware package and reproduce the time-series plot using thegraphic capabilities of your software package. Be sure you use anappropriate title and axis labels. If you do not have access to theappropriate software, provide a rough sketch of the time plot thatis given on the website.

(b) Is there a regular pattern of seasonal variation thatrepeats each year? Describe it. Are the prices increasing overtime?


Answer(a): Plot of time series is plotted above. The state ofCalifornia was selected for analysis.

month price.seasonality.index
January 99.97584
February 98.91215
March 96.11076
April 95.40866
May 100.8078
June 104.0972
July 104.8449
August 103.7426
September 101.9066
October 101.9417
November 95.14643
December 97.10529

Answer(b): Seasonality: from the seasonal indexwe can see that there is no any strong evidence of seasonality butthere are slightly higher prices in the moth of June, July andAugust.

Trend: from the trend graph given below it canbe seen that there is increasing trend in the price over thetime.

"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.