Use the following spreadsheet to work Problems . 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 gallon), column D is U.S. oil production, and column E is the U.S. quantity of gasoline refined.

Draw a scatter diagram of the price of oil and the quantity of U.S. oil produced. Describe the relationship.

Transcribed Image Text:

1 2 3 4 5 6 A 2010 2011 2012 2013 2014 2015 7 2016 8 2017 9 2018 10 2019 11 2020 B 66 72 100 62 79 95 94 98 93 49 45 262 284 330 241 284 358 368 358 344 252 225 D 5.1 5.1 5.0 5.4 5.5 5.6 6.5 7.5 8.8 9.4 8.9 E 15.6 15.4 15.3 14.8 15.2 15.1 15.5 15.2 15.5 16.6 16.4