Refer to Example. The following table lists the average gasoline consumption in miles per gallon (MPG) and the average distance (thousands of miles) driven by cars in each of the years 1980 to 2009. (The file contains the average price of gasoline for each year, the annual CPI (stored in CPI-Annual.xlsx), fuel consumption and distance (thousands.) For each year, calculate the inflation-adjusted cost per year of driving. Use a graphical technique to present theresults.

Transcribed Image Text:

9 1 7 9 1-11 1 1-11 7-15 37 .2 .9 1 1 9 0 61 2 1-11 211 3-76 61 2 1 2 61 211 39 9-61 2-1 980 35 90 41 00 9-39 9-61 Ps