6 Gasoline

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 7

YEAR G PG Y PNC PUC POP Log_G Log_PG

1960 129.7 0.925 6036 1.045 0.836 180.7 4.865224 -0.07796


1961 131.3 0.914 6113 1.045 0.869 183.7 4.877485 -0.08992
1962 137.1 0.919 6271 1.041 0.948 186.5 4.920711 -0.08447
1963 141.6 0.918 6378 1.035 0.96 189.2 4.953006 -0.08556
1964 148.8 0.914 6727 1.032 1.001 191.9 5.002603 -0.08992
1965 155.9 0.949 7027 1.009 0.994 194.3 5.049215 -0.05235
1966 164.9 0.97 7280 0.991 0.97 196.6 5.105339 -0.03046
1967 171 1 7513 1 1 198.7 5.141664 0
1968 183.4 1.014 7728 1.028 1.028 200.7 5.21167 0.013903
1969 195.8 1.047 7891 1.044 1.031 202.7 5.277094 0.045929
1970 207.4 1.056 8134 1.076 1.043 205.1 5.334649 0.054488
1971 218.3 1.063 8322 1.12 1.102 207.7 5.38587 0.061095
1972 226.8 1.076 8562 1.11 1.105 209.9 5.424069 0.07325
1973 237.9 1.181 9042 1.111 1.176 211.9 5.47185 0.166362
1974 225.8 1.599 8867 1.175 1.226 213.9 5.41965 0.469378
1975 232.4 1.708 8944 1.276 1.464 216 5.44846 0.535323
1976 241.7 1.779 9175 1.357 1.679 218 5.487697 0.576051
1977 249.2 1.882 9381 1.429 1.828 220.2 5.518256 0.632335
1978 261.3 1.963 9735 1.538 1.865 222.6 5.565669 0.674474
1979 248.9 2.656 9829 1.66 2.01 225.1 5.517051 0.976821
1980 226.8 3.691 9722 1.793 2.081 227.7 5.424069 1.305897
1981 225.6 4.109 9769 1.902 2.569 230 5.418764 1.41318
1982 228.8 3.894 9725 1.976 2.964 232.2 5.432848 1.359437
1983 239.6 3.764 9930 2.026 3.297 234.3 5.478971 1.325482
1984 244.7 3.707 10421 2.085 3.757 236.3 5.500033 1.310223
1985 245.8 3.738 10563 2.152 3.797 238.5 5.504518 1.318551
1986 269.4 2.921 10780 2.24 3.632 240.7 5.596197 1.071926
1987 276.8 3.038 10859 2.321 3.776 242.8 5.623295 1.111199
1988 279.9 3.065 11186 2.368 3.939 245 5.634432 1.120048
1989 284.1 3.353 11300 2.414 4.019 247.3 5.649326 1.209855
1990 282 3.834 11389 2.451 3.926 249.9 5.641907 1.343909
1991 271.8 3.766 11272 2.538 3.942 252.6 5.605067 1.326013
1992 280.2 3.751 11466 2.528 4.113 255.4 5.635504 1.322022
1993 286.7 3.713 11476 2.663 4.47 258.1 5.658436 1.31184
1994 290.2 3.732 11636 2.754 4.73 260.7 5.67057 1.316944
1995 297.8 3.789 11934 2.815 5.224 263.2 5.696422 1.332102

Source: Council of Economic Advisors, Economic Report of the President, 1996


Log_Y Log_PNC Log_PUC Log_POP
8.705497 0.044017 -0.17913 5.196838
8.718173 0.044017 -0.14041 5.213304
VARIABLES
8.743691 0.040182 -0.0534 5.228431
8.76061 0.034401 -0.04082 5.242805 YEAR = Year
8.813885 0.031499 0.001 5.256974 G = Total Per Capita U.S. gasoline consumption
8.857515 0.00896 -0.00602 5.269403 computed as total expenditure divided by price
8.892886 -0.00904 -0.03046 5.281171 index
8.92439 0 0 5.291796 PG = Price index for gasoline
8.952605 0.027615 0.027615 5.301811
Y = Per capita disposable income
PNC = Price index for new cars
8.973478 0.043059 0.030529 5.311727
PUC = Price index for used cars
9.003808 0.07325 0.042101 5.323498 POP = U.S. total poulation in millions
9.026658 0.113329 0.097127 5.336095
9.055089 0.10436 0.099845 5.346631
9.109636 0.105261 0.162119 5.356114
9.090092 0.161268 0.203757 5.365509
9.098738 0.24373 0.381172 5.375278
9.124238 0.305276 0.518198 5.384495
9.146442 0.356975 0.603222 5.394536
9.183483 0.430483 0.623261 5.405376
9.193092 0.506818 0.698135 5.416545
9.182147 0.58389 0.732849 5.428029
9.186969 0.642906 0.943517 5.438079
9.182455 0.681075 1.08654 5.447599
9.203316 0.706063 1.193013 5.456602
9.251578 0.734769 1.323621 5.465102
9.265113 0.766398 1.334211 5.474369
9.285448 0.806476 1.289783 5.483551
9.29275 0.841998 1.328665 5.492238
9.322418 0.862046 1.370927 5.501258
9.332558 0.881285 1.391033 5.510602
9.340403 0.896496 1.367621 5.521061
9.330077 0.931376 1.371688 5.531807
9.347141 0.927428 1.414153 5.542831
9.348013 0.979453 1.497388 5.553347
9.361859 1.013054 1.553925 5.56337
9.387147 1.034962 1.653263 5.572914
S. gasoline consumption
nditure divided by price

soline
le income
new cars
used cars
ion in millions
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9943308386
R Square 0.9886938166
Adjusted R Square 0.9868094527
Standard Error 0.0285723359
Observations 36

ANOVA
df SS MS F Significance F
Regression 5 2.141699529595 0.4283399059 524.6830597 3.0571305E-28
Residual 30 0.024491351377 0.0008163784
Total 35 2.166190880972

Coefficients Standard Error t Stat P-value Lower 95%


Intercept -8.606693507 1.248751611776 -6.892238157 1.188221E-07 -11.156984529
Log_PG -0.092155541 0.029744743491 -3.098212667 0.004203578 -0.1529024114
Log_Y 2.0014131481 0.196800845001 10.169738591 3.087027E-11 1.59949220295
Log_PNC 0.0839705682 0.126264391275 0.6650376035 0.511107018 -0.1738957203
Log_PUC -0.108119058 0.070412410641 -1.535511389 0.135138782 -0.2519203853
Log_POP -0.76683815 0.522202938238 -1.468467704 0.1523854 -1.8333188269
Upper 95% Lower 95.0% Upper 95.0%
-6.056402486 -11.15698453 -6.056402486
-0.031408671 -0.152902411 -0.031408671
2.4033340932 1.5994922029 2.4033340932
0.3418368567 -0.17389572 0.3418368567
0.0356822684 -0.251920385 0.0356822684
0.2996425278 -1.833318827 0.2996425278
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.9939220941
R Square 0.9878811291
Adjusted R Square 0.9863174038
Standard Error 0.0291003756
Observations 36

ANOVA
df SS MS F Significance F
Regression 4 2.139939093384 0.5349847733 631.7485207 3.2075605E-29
Residual 31 0.026251787588 0.0008468319
Total 35 2.166190880972

Coefficients Standard Error t Stat P-value Lower 95%


Intercept -10.22781157 0.59445633494 -17.20532017 2.056636E-17 -11.440213258
Log_PG -0.077806755 0.028613187315 -2.719262066 0.010622128 -0.1361637351
Log_Y 1.7288442555 0.066613872811 25.953216388 1.365249E-22 1.59298436617
Log_PNC -0.007506038 0.111857592313 -0.067103518 0.946930223 -0.2356411016
Log_PUC -0.112715046 0.07164280945 -1.573291818 0.125803217 -0.2588315191
Upper 95% Lower 95.0% Upper 95.0%
-9.015409881 -11.44021326 -9.015409881
-0.019449775 -0.136163735 -0.019449775
1.8647041448 1.5929843662 1.8647041448
0.2206290256 -0.235641102 0.2206290256
0.0334014273 -0.258831519 0.0334014273

You might also like