Draw a scatter diagram of the quantity of oil produced and the quantity of gasoline refined. Describe the relationship.

The spreadsheet provides data on oil and gasoline:
Column A is the year, column B is the price of oil (dollars per barrel), column C is the price of gasoline (cents per litre), column D is oil production, and column E is the quantity of gasoline refined (both in millions of barrels per day).

Transcribed Image Text:

1 2 3 4 5 6 7 8 9 10 11 A 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 B 31 42 57 66 72 100 62 79 95 94 98 C 42 50 61 69 75 87 64 75 94 96 93 D 5.7 5.4 5.2 5.1 5.1 5.0 5.4 5.5 5.7 6.5 7.5 E 8.9 9.1 9.2 9.3 9.3 9.0 9.0 9.0 9.1 9.0 9.1