{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":63,"n_cols":28,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["VEHICLE FUEL PRICE AND MILES PER GALLON",null,null,null,null,null,"2015-04-01","rev"]
[]
[null,"Sheet 1:  Price and MPH by Year"]
[null,null,null,null,null,null,null,null,"$PG","Dollars per gallon adjusted to 2005 equivalents"]
["MPG Data","http://epa.gov/fueleconomy/fetrends/1975-2014/420r14023a.pdf",null,null,null,null,null,null,"MPG","Miles per gallon"]
["Price Data","http://www.eia.gov/totalenergy/data/annual/showtext.cfm?t=ptb0524",null,null,null,null,null,null,"GPM","Gallons per mile"]
[]
["Year","$PG in 2005 $","MPG","GPM"]
[1970,1.4670000000000001]
[1971,1.4239999999999999]
[1972,1.3540000000000001]
[1973,1.379]
[1974,1.7330000000000001]
[1975,1.69,13.1,7.6335877862595422E-2]
[1976,1.69,14.2,7.0422535211267609E-2]
[1977,1.68,15.1,6.6225165562913912E-2]
[1978,1.61,15.8,6.3291139240506319E-2]
[1979,2.0099999999999998,15.9,6.2893081761006289E-2]
[1980,2.56,19.2,5.2083333333333336E-2]
[1981,2.59,20.5,4.878048780487805E-2]
[1982,2.31,21.1,4.7393364928909949E-2]
[1983,2.13,21,4.7619047619047616E-2]
[1984,2,21,4.7619047619047616E-2]
[1985,1.94,21.3,4.6948356807511735E-2]
[1986,1.48,21.8,4.5871559633027519E-2]
[1987,1.48,22,4.5454545454545456E-2]
[1988,1.44,21.9,4.5662100456621009E-2]
[1989,1.52,21.4,4.6728971962616828E-2]
[1990,1.68,21.2,4.716981132075472E-2]
[1991,1.6,21.3,4.6948356807511735E-2]
[1992,1.55,20.8,4.8076923076923073E-2]
[1993,1.5,20.9,4.784688995215311E-2]
[1994,1.47,20.399999999999999,4.9019607843137261E-2]
[1995,1.48,20.5,4.878048780487805E-2]
[1996,1.55,20.399999999999999,4.9019607843137261E-2]
[1997,1.53,20.2,4.9504950495049507E-2]
[1998,1.3,20.100000000000001,4.9751243781094523E-2]
[1999,1.41,19.7,5.0761421319796954E-2]
[2000,1.76,19.8,5.0505050505050504E-2]
[2001,1.69,19.600000000000001,5.10204081632653E-2]
[2002,1.56,19.5,5.128205128205128E-2]
[2003,1.74,19.600000000000001,5.10204081632653E-2]
[2004,1.99,19.3,5.181347150259067E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","a","b","Yc"]
[2005,2.34,19.899999999999999,5.0251256281407038E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.95,1.89E-2,9.2600000000000002E-2,{"$f":"-(X44*Y44)+Z44","v":5.5745000000000003E-2}]
[2006,2.56,20.100000000000001,4.9751243781094523E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.0499999999999998,1.89E-2,9.2600000000000002E-2,{"$f":"-(X45*Y45)+Z45","v":5.3855000000000007E-2}]
[2007,2.68,20.6,4.8543689320388349E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X45-X44","v":9.9999999999999867E-2},null,null,{"$f":"AA45-AA44","v":-1.8899999999999958E-3},"Delta"]
[2008,3.06,21,4.7619047619047616E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X46/X44","v":5.1282051282051218E-2},null,null,{"$f":"AA46/AA44","v":-3.3904386043591278E-2},"% Delta"]
[2009,2.19,22.4,4.4642857142857144E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA47/X47","v":-0.66113552785003071},"Elasticity"]
[2010,2.56,22.6,4.4247787610619468E-2]
[2011,null,22.4,4.4642857142857144E-2]
[2012,null,23.6,4.2372881355932202E-2]
[2013,null,24.1,4.1493775933609957E-2]
[2014,null,24.2,4.1322314049586778E-2]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","a","b","Yc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.15,6.0000000000000001E-3,5.8900000000000001E-2,{"$f":"-(X59*Y59)+Z59","v":4.5999999999999999E-2},"X1 Y1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.25,6.0000000000000001E-3,5.8900000000000001E-2,{"$f":"-(X60*Y60)+Z60","v":4.5400000000000003E-2},"X2 Y2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X60-X59","v":0.10000000000000009},null,null,{"$f":"AA60-AA59","v":-5.9999999999999637E-4},"Delta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X61/X59","v":4.6511627906976785E-2},null,null,{"$f":"AA61/AA59","v":-1.3043478260869486E-2},"% Delta"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA62/X62","v":-0.2804347826086937},"Elasticity"]

{"sheet":"Sheet2","index":1,"n_rows":53,"n_cols":22,"rows_kept":53,"cut":false,"hidden":false,"merged":[[7,16,7,18],[7,20,7,22],[26,21,26,22],[27,21,27,22],[23,21,23,22],[28,21,28,22],[9,21,9,22],[12,21,12,22],[13,21,13,22],[14,21,14,22]]}
[null,null,null,null,"VEHICLE FUEL PRICE AND MILES PER GALLON",null,null,"rev",null,null,null,null,"2015-04-01","rev"]
[]
[null,null,null,null,null,"Sheet 2:  Correlation between MPG and $PG",null,null,null,null,null,null,null,null,null,null,"$PG","Dollars per gallon adjusted to 2005 equivalents"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MPG","Miles per gallon"]
[null,null,null,null,"MPG Data","http://epa.gov/fueleconomy/fetrends/1975-2014/420r14023a.pdf",null,null,null,null,null,null,null,null,null,null,"GPM","Gallons per mile"]
[null,null,null,null,"Price Data","http://www.eia.gov/totalenergy/data/annual/showtext.cfm?t=ptb0524",null,null,null,null,null,null,null,null,null,null,"a and b","Coeffients from trendline on chart"]
[]
["Year","Price in 2005 $","MPG","GPM","Year","Price in 2005 $","Year",null,"MPG",null,null,null,null,null,null,null,"MPG  =  ( $PG  x  a )  +   b",null,null,null,"GPM  =  1  /  MPG"]
[1970,1.4670000000000001,null,null,1973,1.379,1975,1.69,13.1]
[1971,1.4239999999999999,null,null,1974,1.7330000000000001,1976,1.69,14.2,null,null,null,null,null,null,null,"$PG","a","b","MPG","GPM","Statistic"]
[1972,1.3540000000000001,null,null,1975,1.69,1977,1.68,15.1,null,null,null,null,null,null,null,1.95,6.0069999999999997,6.0144000000000002,{"$f":"(Q11*R11)+S11","v":17.72805},{"$f":"1/T11","v":5.6407783145918475E-2}]
[1973,1.379,null,null,1976,1.69,1978,1.61,15.8,null,null,null,null,null,null,null,2.0499999999999998,6.0069999999999997,6.0144000000000002,{"$f":"(Q12*R12)+S12","v":18.328749999999999},{"$f":"1/T12","v":5.4559094319034308E-2}]
[1974,1.7330000000000001,null,null,1977,1.68,1979,2.0099999999999998,15.9,null,null,null,null,null,null,null,{"$f":"Q12-Q11","v":9.9999999999999867E-2},null,null,null,{"$f":"U12-U11","v":-1.8486888268841664E-3},"Delta"]
[1975,1.69,13.1,7.6335877862595422E-2,1978,1.61,1980,2.56,19.2,null,null,null,null,null,null,null,{"$f":"Q13/Q11","v":5.1282051282051218E-2},null,null,null,{"$f":"U13/U11","v":-3.2773647957443842E-2},"% Delta"]
[1976,1.69,14.2,7.0422535211267609E-2,1979,2.0099999999999998,1981,2.59,20.5,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U14/Q14","v":-0.63908613517015578},"Price Elasticity"]
[1977,1.68,15.1,6.6225165562913912E-2,1980,2.56,1982,2.31,21.1]
[1978,1.61,15.8,6.3291139240506319E-2,1981,2.59,1983,2.13,21]
[1979,2.0099999999999998,15.9,6.2893081761006289E-2]
[1980,2.56,19.2,5.2083333333333336E-2]
[1981,2.59,20.5,4.878048780487805E-2]
[1982,2.31,21.1,4.7393364928909949E-2]
[1983,2.13,21,4.7619047619047616E-2,"Year","Price in 2005 $","Year",null,"MPG"]
[1984,2,21,4.7619047619047616E-2,1999,1.41,2004,1.99,19.3]
[1985,1.94,21.3,4.6948356807511735E-2,2000,1.76,2005,2.34,19.899999999999999,null,null,null,null,null,null,null,"$PG","a","b","MPG","GPM","Statistic"]
[1986,1.48,21.8,4.5871559633027519E-2,2001,1.69,2006,2.56,20.100000000000001,null,null,null,null,null,null,null,2.15,2.8041999999999998,15.77,{"$f":"(Q25*R25)+S25","v":21.799029999999998},{"$f":"1/T25","v":4.5873600797833668E-2}]
[1987,1.48,22,4.5454545454545456E-2,2002,1.56,2007,2.68,20.6,null,null,null,null,null,null,null,2.25,2.8041999999999998,15.77,{"$f":"(Q26*R26)+S26","v":22.079450000000001},{"$f":"1/T26","v":4.5290983244600749E-2}]
[1988,1.44,21.9,4.5662100456621009E-2,2003,1.74,2008,3.06,21,null,null,null,null,null,null,null,{"$f":"Q26-Q25","v":0.10000000000000009},null,null,null,{"$f":"U26-U25","v":-5.8261755323291836E-4},"Delta"]
[1989,1.52,21.4,4.6728971962616828E-2,2004,1.99,2009,2.19,22.4,null,null,null,null,null,null,null,{"$f":"Q27/Q25","v":4.6511627906976785E-2},null,null,null,{"$f":"U27/U25","v":-1.2700497521450983E-2},"% Delta"]
[1990,1.68,21.2,4.716981132075472E-2,2005,2.34,2010,2.56,22.6,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U28/Q28","v":-0.27306069671119587},"Price Elasticity"]
[1991,1.6,21.3,4.6948356807511735E-2,2006,2.56,2011,null,22.4]
[1992,1.55,20.8,4.8076923076923073E-2,2007,2.68,2012,null,23.6]
[1993,1.5,20.9,4.784688995215311E-2,2008,3.06,2013,null,24.1]
[1994,1.47,20.399999999999999,4.9019607843137261E-2]
[1995,1.48,20.5,4.878048780487805E-2]
[1996,1.55,20.399999999999999,4.9019607843137261E-2]
[1997,1.53,20.2,4.9504950495049507E-2]
[1998,1.3,20.100000000000001,4.9751243781094523E-2]
[1999,1.41,19.7,5.0761421319796954E-2]
[2000,1.76,19.8,5.0505050505050504E-2]
[2001,1.69,19.600000000000001,5.10204081632653E-2]
[2002,1.56,19.5,5.128205128205128E-2]
[2003,1.74,19.600000000000001,5.10204081632653E-2]
[2004,1.99,19.3,5.181347150259067E-2]
[2005,2.34,19.899999999999999,5.0251256281407038E-2]
[2006,2.56,20.100000000000001,4.9751243781094523E-2]
[2007,2.68,20.6,4.8543689320388349E-2]
[2008,3.06,21,4.7619047619047616E-2]
[2009,2.19,22.4,4.4642857142857144E-2]
[2010,2.56,22.6,4.4247787610619468E-2]
[2011,null,22.4,4.4642857142857144E-2]
[2012,null,23.6,4.2372881355932202E-2]
[2013,null,24.1,4.1493775933609957E-2]
[2014,null,24.2,4.1322314049586778E-2]