HW- ARE 106 Econometric Theory and Applications Must A (Stata Needed)
OZIPeng
corndemand2020.xlsx
Sheet1
| year | price | CPI | quantity |
| 1926 | 0.6850000024 | 17.2999992371 | 2.04021 |
| 1927 | 0.9850000143 | 17.1000003815 | 2.11819 |
| 1928 | 0.9412999749 | 17 | 2.26099 |
| 1929 | 0.7975000143 | 16.8999996185 | 2.135038 |
| 1930 | 0.5988000035 | 15.6000003815 | 1.757297 |
| 1931 | 0.3325000107 | 14 | 2.229903 |
| 1932 | 0.2574999928 | 12.6000003815 | 2.578685 |
| 1933 | 0.488800019 | 13.3000001907 | 2.104725 |
| 1934 | 0.8324999809 | 13.6999998093 | 1.146734 |
| 1935 | 0.6075000167 | 13.6999998093 | 2.001367 |
| 1936 | 1.1599999666 | 14.1999998093 | 1.258673 |
| 1937 | 0.5788000226 | 14.1000003815 | 2.349425 |
| 1938 | 0.474999994 | 13.8999996185 | 2.300095 |
| 1939 | 0.5777999759 | 14 | 2.341602 |
| 1940 | 0.6696000099 | 14.1999998093 | 2.206882 |
| 1941 | 0.8382999897 | 16 | 2.414445 |
| 1942 | 1.0026000738 | 17.2000007629 | 2.801819 |
| 1943 | 1.0700000525 | 17.3999996185 | 2.66849 |
| 1944 | 1.1641000509 | 17.7999992371 | 2.801612 |
| 1945 | 1.1849999428 | 18.2999992371 | 2.577449 |
| 1946 | 1.7344999313 | 21.8999996185 | 2.916089 |
| 1947 | 2.3399000168 | 23.3999996185 | 2.10832 |
| 1948 | 1.363699913 | 23.7999992371 | 3.307038 |
| 1949 | 1.3763999939 | 23.6000003815 | 2.946206 |
| 1950 | 1.7994999886 | 25.7999992371 | 2.764071 |
| 1951 | 1.8646000624 | 26.2999992371 | 2.628937 |
| 1952 | 1.5952000618 | 26.6000003815 | 2.980793 |
| 1953 | 1.5791000128 | 26.8999996185 | 2.881801 |
| 1954 | 1.4936000109 | 26.7000007629 | 2.707913 |
| 1955 | 1.3494000435 | 26.7999992371 | 2.872959 |
| 1956 | 1.3144999743 | 27.7999992371 | 3.075336 |
| 1957 | 1.1994999647 | 28.7999992371 | 3.045355 |
| 1958 | 1.2223000526 | 28.8999996185 | 3.356205 |
| 1959 | 1.1758999825 | 29.3999996185 | 3.824598 |
| 1960 | 1.1448000669 | 29.7999992371 | 3.906949 |
| 1961 | 1.1308000088 | 30.1000003815 | 3.597803 |
| 1962 | 1.2203999758 | 30.5 | 3.606311 |
| 1963 | 1.241699934 | 30.8999996185 | 4.019238 |
| 1964 | 1.3352999687 | 31.2999992371 | 3.484253 |
| 1965 | 1.2845000029 | 32.0999984741 | 4.102867 |
| 1966 | 1.4141000509 | 33 | 4.167608 |
| 1967 | 1.1712999344 | 34.2999992371 | 4.860372 |
| 1968 | 1.179199934 | 36.0999984741 | 4.449542 |
| 1969 | 1.2437999249 | 38.2000007629 | 4.687057 |
| 1970 | 1.5535999537 | 40 | 4.152243 |
| 1971 | 1.2272000313 | 41.4000015259 | 5.64626 |
| 1972 | 1.5924999714 | 43.2999992371 | 5.579832 |
| 1973 | 2.9889998436 | 47.7999992371 | 5.670712 |
| 1974 | 2.9228000641 | 52.7000007629 | 4.701402 |
| 1975 | 2.711700201 | 55.9000015259 | 5.840757 |
| 1976 | 2.5404000282 | 59.5 | 6.289169 |
| 1977 | 2.3868999481 | 63.4000015259 | 6.505041 |
| 1978 | 2.4623000622 | 69.8000030518 | 7.267927 |
| 1979 | 2.5999999046 | 80.0999984741 | 7.928139 |
| 1980 | 3.4776000977 | 88.5 | 6.639396 |
| 1981 | 2.6464002132 | 94.5 | 8.11865 |
| 1982 | 2.8171999454 | 97.9000015259 | 8.235101 |
| 1983 | 3.3701999187 | 102.5999984741 | 4.174251 |
| 1984 | 2.689800024 | 106.4000015259 | 7.67213 |
| 1985 | 2.2890000343 | 108.8000030518 | 8.875453 |
| 1986 | 1.4660999775 | 112.0999984741 | 8.225764 |
| 1987 | 1.9191000462 | 116.5 | 7.1313 |
| 1988 | 2.6454999447 | 122.3000030518 | 4.928681 |
| 1989 | 2.4470000267 | 128.6999969482 | 7.531953 |
| 1990 | 2.4492998123 | 135 | 7.934028 |
| 1991 | 2.6375000477 | 139.3000030518 | 7.474765 |
| 1992 | 2.1542999744 | 143.6000061035 | 9.476698 |
| 1993 | 2.7545998096 | 147.1999969482 | 6.33773 |
| 1994 | 2.3564999104 | 151.3999938965 | 10.05052 |
| 1995 | 3.9182999134 | 155.6999969482 | 7.400051 |
| 1996 | 2.9007997513 | 160 | 9.232557 |
| 1997 | 2.5851998329 | 162.1999969482 | 9.206832 |
| 1998 | 2.0896000862 | 165 | 9.758685 |
| 1999 | 2.0752000809 | 171.1999969482 | 9.430612 |
| 2000 | 1.918900013 | 176.1999969482 | 9.915051 |
| 2001 | 1.9214999676 | 178.8000030518 | 9.50258 |
| 2002 | 2.3090000153 | 184.1999969482 | 8.966787 |
| 2003 | 2.8892998695 | 187.3999938965 | 10.087292 |
| 2004 | 1.9677000046 | 193.3000030518 | 11.805581 |
| 2005 | 2.0404000282 | 199.8000030518 | 11.112187 |
| 2006 | 3.7573001385 | 205.3520050049 | 10.531123 |
| 2007 | 5.1547498703 | 213.5279998779 | 13.037875 |
| 2008 | 3.5883300304 | 212.7089996338 | 12.043203 |
| 2009 | 3.4010901451 | 217.6309967041 | 13.067156 |
| 2010 | 6.5869598389 | 223.4669952393 | 12.42533 |
| 2011 | 6.4650001526 | 229.391998291 | 12.313956 |
| 2012 | 7.3246302605 | 232.7729949951 | 10.755111 |
| 2013 | 4.6386699677 | 236.2929992676 | 13.828964 |
| 2014 | 3.6683301926 | 236.1190032959 | 14.215532 |