HW- ARE 106 Econometric Theory and Applications Must A (Stata Needed)

profileOZIPeng
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