Economic Project

profileevancjh
EnergyPriceData.xlsx

Data

Year Gas Price Natural Gas Electricity S Prices Index
1993 1.07 6.16 8.32 15.55 100.00%
1994 1.08 6.41 8.38 15.87 102.06%
1995 1.16 6.06 8.4 15.62 100.45%
1996 1.27 6.34 8.36 15.97 102.70%
1997 1.24 6.94 8.43 16.61 106.82%
1998 1.07 6.82 8.26 16.15 103.86%
1999 1.18 6.69 8.16 16.03 103.09%
2000 1.52 7.76 8.24 17.52 112.67%
2001 1.46 9.63 8.63 19.72 126.82%
2002 1.39 7.89 8.43 17.71 113.89%
2003 1.60 9.63 8.72 19.95 128.30%
2004 1.90 10.75 8.94 21.59 138.84%
2005 2.31 12.70 9.43 24.44 157.17%
2006 2.62 13.73 10.37 26.72 171.83%
2007 2.84 13.08 10.64 26.56 170.80%
2008 3.30 13.89 11.25 28.44 182.89%
b. 82.89%
c. 76.10%

b. ((28.44 - 15.55)/15.55)*100 = 82.89% c. ((28.44-16.15)/16.15)*100 = 76.10%

Description

PRICES
File:Prices.xlsx
Column A: year
Column B: $/gallon
Column C: $/thou. cubic feet
Column D: cents/kilowatt hour