Computer Assignment 5 ( Fossil Fuels and Green Energy) The larger data files contain the data for problem 1 and 6 (see Assignment_5 Data File). You will need to create the data files for other...

1

Computer Assignment 5 (Fossil Fuels and Green Energy)
The larger data files contain the data for problem 1 and 6 (see
Assignment_5 Data File). You will need to create the data files for other
problems. Boxes are provided to show the graphs and analysis.
Expand them as needed.
To get full credit, you must provide all charts and graphs with complete analysis
and report.

Name____________________________________________________ Class Day and Time_____________

Case Study 2.3

Fossil Fuels and Green Energy: An article entitled, “The Return of Fossil Fuels” in the
Smart Money (August 2012), a publication of the Wall Street Journal presents some
interesting facts about different sources of energy including the oil, natural gas, and the
green energy. The report states the impact of enormous new oil and gas discoveries in
America and how they are affecting the energy consumption and uses.
The report adds how the oil drillers and related equipment manufacturers are profiting
from big new oil finds. In recent years the dependence on foreign oil has decreased in the
U.S. – from 57% in 2008 to 42% in 2012. Americans are also drilling more oil – increasing
the oil production from 5.0 million barrels per day in 2008 to 6.3 million barrels per day in
2012. This has led to a significant increase in the number of oil rigs in operation in the U.S.
–from 391 in 2008 to 1329 in 2012. Due to increasing demand from the developing world,
oil prices have risen several folds in the past 20 years. But, the infusion of new resources in
horizontal drilling techniques have led to new finds and making the drilling more attractive
and profitable.
Table 2CS.6 below shows the history of oil price in dollars per barrel from 1982 to 2016.
The table shows the average price for the year. The data can be found in the data file
Chapter2CaseData. The columns containing the data are labeled Year and Average Oil
Price ($/barrel).
Table 2CS.6: Average Oil Price ($/barrel) : 1982 – 2012
Year 1982 1983 1984 1885 1986 1987 1988 1989 1990
Av. Price
($)

31.55

29.00

27.50

26.50

19.64

17.50

14.87

18.33

23.19
Year 1991 1992 1993 1994 1995 1996 1997 1998 1999
Av. Price
($)

20.19

19.25

16.74

15.66

16.75

20.46

18.97

11.91

16.55
2
Year 2000 2001 2002 2003 2004 2005 2006 2007 2008
Av. Price
($)

27.40

23.00

22.81

27.69

37.41

50.04

58.30

64.20

91.48
Year 2009 2010 2011 2012 2013 2014 2015 2016
Av. Price
($)

53.56

71.21

87.48

93.61

99.84

53.98

37.20

44.21
Source- www.ioga.com/Special/crudeoil_Hist.htm. *The values for 2013 to 2016 are for the
end of the year. The above data is provide in Assignment _5 Data (Excel file). Open
the data file. Refer to the data from the oil industry to perform the following analysis
1. Prepare a bar chart of the data in Table 2CS.6 to show the average yearly oil price
from 1982 to 2016. Expand the table below as needed to fit your chart.









2. Construct an appropriate chart of the average yearly oil price that will show a trend
or a pattern in the price over the years. Calculate the percent increase/decrease in
the average oil price in the past 20 years and in the past 10 years.
If you don’t remember how to calculate the percent increase or decrease,
examples are provided at the end of this assignment..

Chart showing the trend or pattern
$0.00
$20.00
$40.00
$60.00
$80.00
$100.00
$120.00
1
9
8
2
1
9
8
4
1
9
8
6
1
9
8
8
1
9
9
0
1
9
9
2
1
9
9
4
1
9
9
6
1
9
9
8
2
0
0
0
2
0
0
2
2
0
0
4
2
0
0
6
2
0
0
8
2
0
1
0
2
0
1
2
2
0
1
4
2
0
1
6
A
ve
ra
ge
o
il
p
ri
ce
(
$
/b
ar
re
l)

Year
Bar Chart
http://www.ioga.com/Special/crudeoil_Hist.htm
3










Percent increase/decrease (2006 –
2016)
Price in 2006 = $58.30
Price in 2016 = $44.21

Percent decrease = ($44.21 -
$58.30)/$58.30
Percent decrease = -24.17%


Percent increase/decrease (1996 – 2016)

Price in 1996 = $20.46
Price in 2016 = $44.21

Percent increase = ($44.21 - $20.46)/$20.46
Percent increase = 116.08%
3. Refer to the data about the oil production and number of oil rigs from 2008 to 2012
(second paragraph of page 1) and determine the percent increase in U.S. oil
production in barrels per day and also the number of oil rigs.

Percent increase in U.S. oil production in barrels per day and also the number
of...