14 Draw a scatter diagram of the quantities of oil produced and petrol refined. Describe the relationship The spreadsheet provides data on oil and petrol: column A is the year, column B is the price of oil (dollars per barrel), column C is the price of petrol (pence per litre), column D is oil production and column E is the quantity of petrol refined (both in millions of barrels per day).

Transcribed Image Text:

A B C D E 1 2005 54 87 74 58 2 2006 65 91 73 57 3 2007 72 94 73 57 4 2008 97 107 74 55 5 2009 61 99 73 53 6 2010 80 117 75 52 7 2011 111 133 75 50 8 2012 112 135 76 50 9 2013 109 134 76 49 10 2014 99 127 78 49 11 2015 52 111 78 48