Econometric. Stata.
text book material: http://jaimedv.com/eco/4c1-ecomet/jeffrey-m-wooldridge–econometrics–book.pdf
Name: __________________________________________________
Econometrics
DUE TUES Aug 18th by 11:59PM (EST)
Please read each question carefully and answer it completely. Please provide STATA output in the Appendix although be aware I will only look at your output if I suspect there are issues with your estimations/STATA commands I will not search through output for answers to questions that should be included in the main body of your exam.
IMPORTANT: I have not cleaned up these data sets, although I have in some cases renamed them, which means that there are variables that you may not be using to answer these questions. For your four-step hypothesis tests, please be sure to include both the critical value and p-value approaches, where possible. Unless otherwise specified use = 0.05.
#1. For this question you will be using the data Spain Phillips, i.e. data for the inflation and unemployment rate in Spain
(i) Use the Spain data to estimate the model in equation [11.19] contained in Example 11.5 dealing with the Phillips curve. [Expectations Augmented Phillips Curve]. Create any necessary variables.
Report your estimated equation (including R2). Briefly define the natural rate of unemployment [using cited outside resources if necessary] and explain how your textbook author uses this estimated model to get an estimate of the natural rate of unemployment from this model. What is the estimated natural rate of unemployment based on your model?
(ii) Conduct a four-step Durbin-Watson test for serial correlation for this model. Based on this result, is it reasonable to, as the textbook suggests, estimate this model assuming TS.1 through TS.5 hold?
(iii) In Chapter 15: C7 the authors suggest an IV estimation for this model. Why might IV estimation be necessary? Test the appropriateness of the instrument the question suggests, show/explain. Estimate the model using the IV estimation outlined in this question. Report your estimated model and compare it with the OLS results you obtained in (i). Does the (point) estimate of the natural rate of unemployment change with this estimation? Show/ Explain.
FOR THIS QUESTION: you DO NOT have to answer the questions in the textbook for Chapter 15: C7 specifically, just use the question to inform your own work. Please use STATA to estimate the IV regression.
(iv) Do you suspect that either the inflation rate or the unemployment rate has a unit root? Defend your viewpoint with specific evidence using the two methods from our homework assignment. Formally four-step hypothesis test where appropriate.
(v) Some economists complain that unit root tests have low power. Explain specifically what that means in terms of unit root hypothesis testing and why that is not a good characteristic of a hypothesis test.
#2. For this question you will be using the data set fertilfinal. Note that this dataset [FERTIL1.RAW] is discussed in your textbook in Example 13.1.
(i) Using the base model presented in the regression output in Table 31.1 (excluding the six time dummies) run the regression model for kids first using the data for 1974 and then for the data using 1984 (i.e. two different cross-section regressions). Report these estimated models and highlight three key differences between these two regressions. Can you directly compare the R2 values for these three models? Explain why or why not.
(ii) For this part of the question you will ONLY use the data for the years 1982 and 1984. Conduct a four-step hypothesis test for a Chow Test of Structural Change using these two years. Again, use the base model set of X-regressors, the same set you used in (i). Set = 0.05. IMPORTANT: Please use the format of the test that is consistent with Chow test you used before in this class, do not use the interactions approach. Note that both are discussed in Example 13.2.
(iii) As discussed in 13: C1 (iii), conduct a four-step hypothesis for heteroskedasticity in the base model (as given in Table 13.1), note that this test is based on whether the variance of u changes over time but not with the other variables. [Hint: Conduct a Breusch-Pagan F-test in STATA.] Set = 0.05.
#3. For this question you will be using the data set jtrain.
(i) Using this data, estimate the model as given in Chapter 14: C3 first with then without fixed effects. Fill in this table using the output for the two estimated models and briefly compare the results. Add an explanation, where possible, for why FE might have caused the change(s) you observe.
Independent Variables
Pooled OLS
Fixed Effects
grant
( )
( )
grant(t-1)
( )
( )
ln(employ)
( )
( )
d88
( )
( )
d89
( )
( )
(ii) Using the STATA output for fixed effects estimation, conduct a four-step hypothesis test for the joint significance on the fixed effects.
Appendix (software output):
2 Data
Year Inflation Unemployment
1970 5.7311558398 1.1000000238
1971 8.2368806299 1.5
1972 8.2722877284 1.5
1973 11.4167092625 2.4900000095
1974 15.680378316 3.0399999619
1975 16.9532824334 4.8000001907
1976 17.6248756067 2.9000000954
1977 24.538063397 5.1999998093
1978 19.7736832132 6.9699997902
1979 15.6602266826 8.6099996567
1980 15.5618949024 11.3999996185
1981 14.5493586775 14.1700000763
1982 14.4149958198 16
1983 12.174083518 17.4899997711
1984 11.2802636666 20.25
1985 8.8144548088 21.6399993896
1986 8.7949397469 21.2586994171
1987 5.2480217669 20.6068000793
1988 4.8372646992 19.8533992767
1989 6.7914375331 17.3311004639
1990 6.7218253011 16.2724990845
1991 5.9342111132 15.9285001755
1992 5.9245342873 17.701499939
1993 4.5690708846 22.1606006622
1994 4.7184132838 24.2087001801
1995 4.6738031852 22.6748008728
1996 3.5588408312 22.1418991089
1997 1.9710789044 20.697599411
1998 1.8343292291 18.6735992432
1999 2.3103469498 15.4756002426
2000 3.4335167555 13.785200119
2001 3.5898349489 10.3479003906
2002 3.0657653719 11.1461000443
2003 3.0392336843 11.2833995819
2004 3.0392016501 11.0902004242
2005 3.3684539879 9.1463003159
2006 3.5153749113 8.4521999359
2007 2.7870304731 8.2320995331
2008 4.0756607637 11.2545003891
2009 -0.287996835 17.8567008972
2010 1.7998813305 19.8596992493
2011 3.1961464122 21.390499115
2012 2.4460001854 24.7872009277
2013 1.4085462924 26.0935993195
2014 -0.1508703135 24.4412994385
2015 -0.5004613214 22.0573005676
2016 -0.2026717408 19.6347007751
2017 1.9560833333 17.2236003876
2018 1.6750676149 15.254699707
2019 0.6995362417 14.1042003632
data description
Code License Type Indicator Name Long definition Source Topic Periodicity Aggregation method Statistical concept and methodology Development relevance Limitations and exceptions General comments License URL
FP.CPI.TOTL.ZG CC BY-4.0 Inflation, consumer prices (annual %) Inflation as measured by the consumer price index reflects the annual percentage change in the cost to the average consumer of acquiring a basket of goods and services that may be fixed or changed at specified intervals, such as yearly. The Laspeyres formula is generally used. International Monetary Fund, International Financial Statistics and data files. Financial Sector: Exchange rates & prices Annual Median https://datacatalog.worldbank.org/public-licenses#cc-by
SL.UEM.TOTL.NE.ZS CC BY-4.0 Unemployment, total (% of total labor force) (national estimate) Unemployment refers to the share of the labor force that is without work but available for and seeking employment. Definitions of labor force and unemployment differ by country. International Labour Organization, ILOSTAT database. Data retrieved in June 21, 2020. Social Protection & Labor: Unemployment Annual Weighted average The standard definition of unemployed persons is those individuals without work, seeking work in a recent past period, and currently available for work, including people who have lost their jobs or who have voluntarily left work. Persons who did not look for work but have an arrangements for a future job are also counted as unemployed.
Some unemployment is unavoidable. At any time some workers are temporarily unemployed between jobs as employers look for the right workers and workers search for better jobs. It is the labour force or the economically active portion of the population that serves as the base for this indicator, not the total population. Paradoxically, low unemployment rates can disguise substantial poverty in a country, while high unemployment rates can occur in countries with a high level of economic development and low rates of poverty. In countries without unemployment or welfare benefits people eke out a living in vulnerable employment. In countries with well-developed safety nets workers can afford to wait for suitable or desirable jobs. But high and sustained unemployment indicates serious inefficiencies in resource allocation.
Youth unemployment is an important policy issue for many economies. Young men and women today face increasing uncertainty in their hopes of undergoing a satisfactory transition in the labour market, and this uncertainty and disillusionment can, in turn, have damaging effects on individuals, communities, economies and society at large. Unemployed or underemployed youth are less able to contribute effectively to national development and have fewer opportunities to exercise their rights as citizens. They have less to spend as consumers, less to invest as savers and often have no “voice” to bring about change in their lives and communities. Widespread youth unemployment and underemployment also prevents companies and countries from innovating and developing competitive advantages based on human capital investment, thus undermining future prospects.
Unemployment is a key measure to monitor whether a country is on track to achieve the Sustainable Development Goal of promoting sustained, inclusive and sustainable economic growth, full and productive employment and decent work for all. [SDG Indicator 8.5.2] The criteria for people considered to be seeking work, and the treatment of people temporarily laid off or seeking work for the first time, vary across countries. In many cases it is especially difficult to measure employment and unemployment in agriculture. The timing of a survey can maximize the effects of seasonal unemployment in agriculture. And informal sector employment is difficult to quantify where informal activities are not tracked.
There may be also persons not currently in the labour market who want to work but do not actively “seek” work because they view job opportunities as limited, or because they have restricted labour mobility, or face discrimination, or structural, social or cultural barriers. The exclusion of people who want to work but are not seeking work (often called the “hidden unemployed” or “discouraged workers”) is a criterion that will affect the unemployment count of both women and men.
However, women tend to be excluded from the count for various reasons. Women suffer more from discrimination and from structural, social, and cultural barriers that impede them from seeking work. Also, women are often responsible for the care of children and the elderly and for household affairs. They may not be available for work during the short reference period, as they need to make arrangements before starting work. Further, women are considered to be employed when they are working part-time or in temporary jobs, despite the instability of these jobs or their active search for more secure employment. The series for ILO estimates is also available in the WDI database. Caution should be used when comparing ILO estimates with national estimates. https://datacatalog.worldbank.org/public-licenses#cc-by
Data from database: World Development Indicators
Last Updated: 07/01/2020
https://databank.worldbank.org/source/world-development-indicators# Sheet1
year fcode employ sales avgsal scrap rework tothrs union grant d89 d88 totrain hrsemp lscrap lemploy lsales lrework lhrsemp lscrap_1 grant_1 clscrap cgrant clemploy clsales lavgsal clavgsal cgrant_1 chrsemp clhrsemp
1987 410032 100 4.70E+07 35000 12 0 0 0 0 100 12 4.60517 17.66566 2.564949 0 0 10.4631
1988 410032 131 4.30E+07 37000 8 0 0 0 1 50 3.053435 4.875197 17.57671 1.399565 0 0 0.2700272 -0.0889492 10.51867 0.0555696 0 -8.946565 -1.165385
1989 410032 123 4.90E+07 39000 8 0 0 1 0 50 3.252033 4.812184 17.70733 1.447397 0 0 -0.0630131 0.130621 10.57132 0.0526438 0 0.1985974 0.0478324
1987 410440 12 1560000 10500 12 0 0 0 0 12 12 2.484907 14.2602 2.564949 0 0 9.25913
1988 410440 13 1970000 11000 12 0 0 0 1 13 12 2.564949 14.49354 2.564949 0 0 0.0800426 0.2333469 9.305651 0.0465202 0 0 0
1989 410440 14 2350000 11500 10 0 0 1 0 14 10 2.639057 14.66993 2.397895 0 0 0.0741081 0.1763821 9.350102 0.0444517 0 -2 -0.1670539
1987 410495 20 750000 17680 50 0 0 0 0 15 37.5 2.995732 13.52783 3.650658 0 0 9.78019
1988 410495 25 110000 18720 50 0 0 0 1 10 20 3.218876 11.60824 3.044523 0 0 0.2231436 -1.919593 9.837348 0.0571585 0 -17.5 -0.6061356
1989 410495 24 950000 19760 50 0 0 1 0 20 41.66667 3.178054 13.76422 3.753418 0 0 -0.040822 2.155982 9.891415 0.0540667 0 21.66667 0.7088954
1987 410500 200 2.37E+07 13729 0 0 0 0 0 0 0 5.298317 16.98271 0 0 0 9.527266
1988 410500 155 1.97E+07 14287 0 0 0 0 1 0 0 5.043425 16.79405 0 0 0 -0.2548923 -0.1886673 9.567105 0.0398397 0 0 0
1989 410500 80 2.60E+07 15758 24 0 0 1 0 20 6 4.382027 17.0733 1.94591 0 0 -0.6613984 0.279253 9.665104 0.0979986 0 6 1.94591
1987 410501 6000000 0 0 0 0 0 10 15.60727 0 0
1988 410501 8000000 0 0 0 0 1 20 15.89495 0 0 0.2876816 0
1989 410501 1.00E+07 0 0 0 1 0 25 16.1181 0 0 0.2231436 0
1987 410509 0 0 0 0 0 0 0 0
1988 410509 2800000 18000 0 0 0 0 1 0 14.84513 0 0 9.798127 0
1989 410509 20 3400000 18500 0 0 0 1 0 0 0 2.995732 15.03929 0 0 0 0.1941557 9.825526 0.0273991 0
1987 410513 15 1413900 18465 0 0 0 0 0 0 0 2.70805 14.16186 0 0 0 9.823632
1988 410513 16 1869348 18972 0 0 0 0 1 0 0 2.772589 14.4411 0 0 0 0.0645385 0.2792377 9.850719 0.0270872 0 0 0
1989 410513 16 1857765 19589 20 0 0 1 0 16 20 2.772589 14.43489 3.044523 0 0 0 -0.0062151 9.882724 0.0320044 0 20 3.044523
1987 410517 24 13000 0 1 0 0 0 0 0 3.178054 0 0 0 9.472705
1988 410517 20 12168 0 1 0 0 1 0 0 2.995732 0 0 0 -0.1823215 9.406565 -0.0661402 0 0 0
1989 410517 18 11960 0 1 0 1 0 0 0 2.890372 0 0 0 -0.1053605 9.389323 -0.0172415 0 0 0
1987 410518 48 2160900 14352 14 0 0 0 0 3 0.875 3.871201 14.58604 0.6286086 0 0 9.571645
1988 410518 47 2454500 16328 14 0 0 0 1 3 0.893617 3.850147 14.71343 0.6384888 0 0 -0.0210536 0.1273975 9.700637 0.1289921 0 0.018617 0.0098801
1989 410518 66 3359800 17555 14 0 0 1 0 4 0.8484849 4.189655 15.02739 0.6143663 0 0 0.3395073 0.3139591 9.773094 0.0724573 0 -0.0451322 -0.0241225
1987 410521 17 1453081 16454 150 0 0 0 0 5 44.11765 2.833213 14.1892 3.809273 0 0 9.708323
1988 410521 16 1546911 18529 100 0 0 0 1 3 18.75 2.772589 14.25177 2.983154 0 0 -0.0606246 0.0625744 9.827092 0.1187687 0 -25.36765 -0.8261199
1989 410521 14 1672366 26428 0 0 0 1 0 0 0 2.639057 14.32975 0 0 0 -0.1335313 0.0779791 10.18218 0.3550873 0 -18.75 -2.983154
1987 410523 70 8000000 19760 0.06 40 0 0 0 0 35 20 -2.813411 4.248495 15.89495 3.044523 0 0 9.891415
1988 410523 85 1.10E+07 22360 0.05 40 0 0 0 1 40 18.82353 -2.995732 4.442651 16.21341 2.98687 -2.813411 0 -0.1823215 0 0.1941562 0.3184538 10.01503 0.1236143 0 -1.17647 -0.057653
1989 410523 98 1.50E+07 23920 0.05 60 0 0 1 0 40 24.4898 -2.995732 4.584968 16.52356 3.238278 -2.995732 0 0 0 0.1423163 0.3101559 10.08247 0.067441 0 5.666265 0.2514086
1987 410529 45 1535242 20000 0 0 0 0 0 0 0 3.806663 14.2442 0 0 0 9.903487
1988 410529 47 3209188 22000 0 0 0 0 1 0 0 3.850147 14.98153 0 0 0 0.0434849 0.7373295 9.998797 0.0953102 0 0 0
1989 410529 51 4030352 23650 2 0 0 1 0 2 0.0784314 3.931826 15.20936 0.0755076 0 0 0.0816782 0.2278357 10.07112 0.0723209 0 0.0784314 0.0755076
1987 410531 200 1.00E+07 17500 5 0 1 0 0 0 0 0 5.298317 16.1181 1.609438 0 0 0 9.769957
1988 410531 200 1.00E+07 18700 4 20 1 0 0 1 6 0.6 5.298317 16.1181 1.386294 0.4700036 0 0 0 0 9.836279 0.0663223 0 0.6 0.4700036
1989 410531 190 9000000 18300 2.22 20 1 0 1 0 10 1.052632 5.247024 16.01274 0.7975072 0.7191227 0 0 -0.0512934 -0.10536 9.814656 -0.0216227 0 0.4526316 0.2491191
1987 410533 14 1600000 11500 68 0 0 0 0 3 14.57143 2.639057 14.28551 2.745438 0 0 9.350102
1988 410533 12 900000 13000 75 0 0 0 1 5 31.25 2.484907 13.71015 3.473518 0 0 -0.1541507 -0.5753641 9.472705 0.1226025 0 16.67857 0.7280805
1989 410533 16 1300000 14700 35 0 0 1 0 9 19.6875 2.772589 14.07788 3.02953 0 0 0.2876821 0.3677254 9.595603 0.1228981 0 -11.5625 -0.4439886
1987 410535 10 420664 4237 0 0 0 0 0 0 0 2.302585 12.94959 0 0 0 8.351611
1988 410535 11 544602 7484 0 0 0 0 1 0 0 2.397895 13.20781 0 0 0 0.0953102 0.2582207 8.920523 0.5689116 0 0 0
1989 410535 9 495331 9548 0 0 0 1 0 0 0 2.197225 13.11298 0 0 0 -0.2006707 -0.0948286 9.164087 0.2435646 0 0 0
1987 410536 15 1502502 11742 12 0 0 0 0 2 1.6 2.70805 14.22264 0.9555115 0 0 9.370928
1988 410536 16 1840912 12740 12 0 0 0 1 2 1.5 2.772589 14.42577 0.9162908 0 0 0.0645385 0.2031298 9.452502 0.0815744 0 -0.1 -0.0392207
1989 410536 18 2273869 13700 8 0 0 1 0 3 1.333333 2.890372 14.63699 0.8472979 0 0 0.1177831 0.2112217 9.525151 0.072649 0 -0.1666666 -0.0689929
1987 410538 19760 2.64 0 1 0 0 0 0 0.9707789 0 0 9.891415
1988 410538 6276271 20800 2.74 0 1 0 0 1 0 1.007958 15.65229 0.9707789 0 0.037179 0 9.942708 0.0512934 0
1989 410538 60 5286605 20800 2.54 30 1 0 1 0 50 25 0.9321641 4.094345 15.48069 3.258096 1.007958 0 -0.0757939 0 -0.1715994 9.942708 0 0
1987 410540 50 5200000 20000 0 0 0 0 0 0 0 3.912023 15.46417 0 0 0 9.903487
1988 410540 50 6500000 23000 0 0 0 0 1 0 0 3.912023 15.68731 0 0 0 0 0.2231436 10.04325 0.1397619 0 0 0
1989 410540 55 5600000 25000 0 0 0 1 0 0 0 4.007333 15.53828 0 0 0 0.0953102 -0.1490355 10.12663 0.0833817 0 0 0
1987 410544 30 19760 0 0 0 0 0 0 0 3.401197 0 0 0 9.891415
1988 410544 32 20280 10 0 0 0 1 4 1.25 3.465736 0.8109302 0 0 0.0645385 9.917391 0.0259762 0 1.25 0.8109302
1989 410544 34 20800 10 0 0 1 0 6 1.764706 3.526361 1.016934 0 0 0.0606246 9.942708 0.0253172 0 0.5147059 0.2060041
1987 410546 153 1.00E+07 12500 8 0 0 0 0 7 0.3660131 5.030438 16.1181 0.3118963 0 0 9.433484
1988 410546 134 1.10E+07 13000 8 0 0 0 1 6 0.358209 4.89784 16.21341 0.3061669 0 0 -0.1325979 0.0953102 9.472705 0.0392208 0 -0.0078041 -0.0057294
1989 410546 146 1.20E+07 13500 40 0 0 1 0 28 7.671233 4.983607 16.30042 2.160011 0 0 0.0857668 0.0870113 9.510445 0.0377398 0 7.313024 1.853844
1987 410547 20 2300000 20000 10 0 0 0 0 0 0 0 2.995732 14.64842 2.302585 0 0 0 9.903487
1988 410547 23 2500000 23000 10 0 0 0 0 1 0 0 3.135494 14.7318 2.302585 0 0 0 0.1397619 0.0833817 10.04325 0.1397619 0 0 0
1989 410547 25 3000000 25000 10 48 0 0 1 0 1 1.92 3.218876 14.91412 2.302585 1.071584 0 0 0.0833817 0.1823215 10.12663 0.0833817 0 1.92 1.071584
1987 410556 0 0 0 0 0 0 0 0
1988 410556 0 0 0 0 1 0 0 0 0
1989 410556 131 7588770 16640 0 0 0 1 0 0 0 4.875197 15.84218 0 0 0 9.719564 0
1987 410560 22 725000 9000 0 0 0 0 0 0 0 3.091043 13.49393 0 0 0 9.10498
1988 410560 25 785000 9000 0 0 0 0 1 0 0 3.218876 13.57344 0 0 0 0.1278334 0.0795116 9.10498 0 0 0 0
1989 410560 23 785000 10000 0 0 0 1 0 0 0 3.135494 13.57344 0 0 0 -0.0833817 0 9.21034 0.105361 0 0 0
1987 410561 6 501859 0 0 0 0 0 0 0 1.791759 13.12607 0 0 0
1988 410561 6 580415 0 0 0 0 1 0 0 1.791759 13.2715 0 0 0 0 0.1454239 0 0 0
1989 410561 9 735442 64 0 0 1 0 1 7.111111 2.197225 13.50823 2.093235 0 0 0.4054651 0.2367287 0 7.111111 2.093235
1987 410562 15 4000000 32000 10 0 0 0 0 2 1.333333 2.70805 15.20181 0.8472979 0 0 10.37349
1988 410562 18 5000000 34000 10 0 0 0 1 2 1.111111 2.890372 15.42495 0.7472144 0 0 0.1823215 0.2231436 10.43412 0.0606241 0 -0.2222222 -0.1000835
1989 410562 19 7000000 38000 25 0 0 1 0 6 7.894737 2.944439 15.76142 2.18546 0 0 0.0540671 0.3364716 10.54534 0.1112261 0 6.783626 1.438245
1987 410563 73 5300000 21500 6 0 1 0 0 0 0 0 1.791759 4.29046 15.48322 0 0 0 9.975808
1988 410563 76 5800000 22200 7 0 1 0 0 1 0 0 1.94591 4.330733 15.57337 0 1.791759 0 0.1541506 0 0.0402737 0.0901508 10.00785 0.0320396 0 0 0
1989 410563 80 6400000 23000 5 50 1 0 1 0 8 5 1.609438 4.382027 15.67181 1.791759 1.94591 0 -0.3364722 0 0.0512934 0.0984402 10.04325 0.0354013 0 5 1.791759
1987 410564 160 20000 4.3 20 0 0 0 0 15 1.875 5.075174 1.458615 1.056053 0 0 9.903487
1988 410564 150 21000 4.1 20 0 0 0 1 20 2.666667 5.010635 1.410987 1.299283 0 0 -0.0645385 9.952278 0.0487909 0 0.7916667 0.2432303
1989 410564 150 22000 4 25 0 0 1 0 35 5.833333 5.010635 1.386294 1.921813 0 0 0 9.998797 0.0465193 0 3.166667 0.6225296
1987 410565 90 20620 21 0 1 0 0 0 0 0 3.044523 4.49981 0 0 0 9.934017
1988 410565 112 2.18E+07 20180 11 0 1 0 0 1 0 0 2.397895 4.718499 16.8965 0 3.044523 0 -0.6466272 0 0.218689 9.912447 -0.0215702 0 0 0
1989 410565 128 2.58E+07 21500 0.4 16 1 0 1 0 128 16 -0.9162907 4.85203 17.06701 2.833213 2.397895 0 -3.314186 0 0.1335316 0.1705055 9.975808 0.0633612 0 16 2.833213
1987 410566 14 2101581 14850 7 8 0 0 0 0 12 6.857143 1.94591 2.639057 14.5582 2.061423 0 0 9.605755
1988 410566 16 2400723 18100 5 3 0 0 0 1 10 1.875 1.609438 2.772589 14.69128 1.056053 1.94591 0 -0.3364722 0 0.1335313 0.1330795 9.803667 0.1979122 0 -4.982143 -1.00537
1989 410566 13 2470633 20500 4.5 4 0 0 1 0 10 3.076923 1.504077 2.564949 14.71999 1.405343 1.609438 0 -0.1053605 0 -0.2076395 0.0287046 9.92818 0.1245127 0 1.201923 0.3492899
1987 410567 40 3000000 10000 1 0.5 0 0 0 0 0 0 0 0 3.688879 14.91412 -0.6931472 0 0 0 9.21034
1988 410567 48 3800000 11000 0.5 0.25 0 0 0 0 1 0 0 -0.6931472 3.871201 15.15051 -1.386294 0 0 0 -0.6931472 0 0.1823215 0.2363892 9.305651 0.0953102 0 0 0
1989 410567 50 3100000 11500 0.28 0.13 16 0 0 1 0 50 16 -1.272966 3.912023 14.94691 -2.040221 2.833213 -0.6931472 0 -0.5798185 0 0.040822 -0.203599 9.350102 0.0444517 0 16 2.833213
1987 410569 20 26000 0 0 0 0 0 0 0 2.995732 0 0 0 10.16585
1988 410569 24 28000 0 0 0 0 1 0 0 3.178054 0 0 0 0.1823215 10.23996 0.0741081 0 0 0
1989 410569 30 30000 0 0 0 1 0 0 0 3.401197 0 0 0 0.2231436 10.30895 0.0689926 0 0 0
1987 410571 17 755050 10400 0.01 25 0 0 0 0 17 25 2.833213 13.53454 -4.60517 3.258096 0 0 9.249561
1988 410571 15 1102723 10400 0.01 25 0 0 0 1 15 25 2.70805 13.91329 -4.60517 3.258096 0 0 -0.1251631 0.3787537 9.249561 0 0 0 0
1989 410571 20 1073785 10400 0.01 25 0 0 1 0 10 12.5 2.995732 13.8867 -4.60517 2.60269 0 0 0.2876821 -0.0265923 9.249561 0 0 -12.5 -0.6554067
1987 410577 75 4750000 16120 1.68 1.89 3 0 0 0 0 30 1.2 0.5187938 4.317488 15.37366 0.6365768 0.7884574 0 0 9.687816
1988 410577 80 5100000 16432 1.57 1.76 4 0 0 0 1 35 1.75 0.4510756 4.382027 15.44475 0.5653138 1.011601 0.5187938 0 -0.0677181 0 0.0645385 0.0710955 9.706985 0.0191698 0 0.55 0.2231436
1989 410577 94 5500000 16640 1.64 1.82 4 0 0 1 0 35 1.489362 0.4946962 4.543295 15.52026 0.5988365 0.9120263 0.4510756 0 0.0436206 0 0.1612682 0.0755081 9.719564 0.012579 0 -0.2606384 -0.0995747
1987 410586 116 1.10E+07 23500 47 0 0 0 0 96 38.89655 4.75359 16.21341 3.68629 0 0 10.06476
1988 410586 114 1.10E+07 24000 47 0 0 0 1 94 38.75439 4.736198 16.21341 3.68272 0 0 -0.0173917 0 10.08581 0.0210533 0 -0.1421661 -0.0035698
1989 410586 119 1.10E+07 24600 47 0 0 1 0 99 39.10084 4.779123 16.21341 3.691397 0 0 0.0429249 0 10.1105 0.0246925 0 0.3464546 0.0086772
1987 410591 25 12180 0 0 0 0 0 0 0 3.218876 0 0 0 9.407551
1988 410591 33 13000 50 0 0 0 1 1 1.515152 3.496508 0.9223331 0 0 0.2776318 9.472705 0.0651541 0 1.515152 0.9223331
1989 410591 37 14500 40 0 0 1 0 2 2.162162 3.610918 1.151256 0 0 0.1144102 9.581903 0.1091986 0 0.6470106 0.2289229
1987 410592 20 30 40 0 0 0 0 20 3.401197 2.995732 3.688879 0 0
1988 410592 20 24 27 0 0 0 1 20 3.178054 2.995732 3.295837 3.401197 0 -0.2231436 0 0 0
1989 410592 10 20 15 0 0 1 0 10 2.995732 2.302585 2.70805 3.178054 0 -0.1823215 0 -0.6931472 0
1987 410593 5 3500000 1 0 0 0 0 0 0 0 0 1.609438 15.06827 0 0 0
1988 410593 5 3800000 1 0 0 0 0 1 0 0 0 1.609438 15.15051 0 0 0 0 0 0 0.0822382 0 0 0
1989 410593 5 4000000 1 0 0 0 1 0 0 0 0 1.609438 15.20181 0 0 0 0 0 0 0.0512934 0 0 0
1987 410596 8 990400 12480 10 10 0 0 0 0 8 10 2.302585 2.079442 13.80586 2.397895 0 0 9.431883
1988 410596 16 1166100 13520 6 12 0 0 0 1 16 12 1.791759 2.772589 13.96918 2.564949 2.302585 0 -0.5108256 0 0.6931472 0.163311 9.511926 0.0800428 0 2 0.1670539
1989 410596 20 1815900 14560 4 14 0 0 1 0 20 14 1.386294 2.995732 14.41209 2.70805 1.791759 0 -0.4054651 0 0.2231436 0.4429169 9.586033 0.0741072 0 2 0.143101
1987 410603 10 1212478 12700 105 0 0 0 0 4 42 2.302585 14.00818 3.7612 0 0 9.449357
1988 410603 14 1159622 13600 105 0 0 0 1 3 22.5 2.639057 13.9636 3.157 0 0 0.3364723 -0.0445719 9.517825 0.0684681 0 -19.5 -0.6041999
1989 410603 17 1612170 14900 0 0 1 0 0 2.833213 14.29309 0 0 0.1941559 0.3294868 9.609117 0.0912914 0
1987 410604 60 8320 0 0 0 0 0 0 0 4.094345 0 0 0 9.026418
1988 410604 100 8940 0 0 0 0 1 0 0 4.60517 0 0 0 0.5108256 9.09829 0.0718727 0 0 0
1989 410604 190 10400 0 0 0 1 0 0 0 5.247024 0 0 0 0.6418538 9.249561 0.1512709 0 0 0
1987 410606 124 1.05E+07 0.66 10 0 0 0 0 43 3.467742 -0.4155154 4.820282 16.16755 1.496883 0 0
1988 410606 127 1.22E+07 14538 0.34 8 0 0 0 1 30 1.889764 -1.07881 4.844187 16.31472 1.061175 -0.4155154 0 -0.6632942 0 0.0239058 0.1471653 9.584521 0 -1.577978 -0.4357084
1989 410606 128 1.20E+07 14865 0.39 28 0 0 1 0 87 19.03125 -0.9416085 4.85203 16.30371 2.997293 -1.07881 0 0.1372011 0 0.007843 -0.0110111 9.606765 0.0222435 0 17.14149 1.936119
1987 410609 22 1650831 24900 0 0 0 0 0 0 0 3.091043 14.31679 0 0 0 10.12262
1988 410609 37 1817961 23000 0 0 0 0 1 0 0 3.610918 14.41323 0 0 0 0.5198753 0.0964365 10.04325 -0.0793743 0 0 0
1989 410609 44 1642441 23200 0 0 0 1 0 0 0 3.78419 14.31169 0 0 0 0.1732719 -0.101532 10.05191 0.0086584 0 0 0
1987 410612 60 7000000 8840 12 0 0 0 0 60 12 4.094345 15.76142 2.564949 0 0 9.087042
1988 410612 65 8500000 9880 12 0 0 0 1 65 12 4.174387 15.95558 2.564949 0 0 0.0800428 0.1941566 9.198268 0.1112261 0 0 0
1989 410612 70 1.10E+07 10920 12 0 0 1 0 70 12 4.248495 16.21341 2.564949 0 0 0.0741076 0.2578287 9.298351 0.1000834 0 0 0
1987 410626 27 4600000 18000 0.87 24 1 0 0 0 3 2.666667 -0.1392621 3.295837 15.34157 1.299283 0 0 9.798127
1988 410626 28 4900000 19000 0.82 16 1 0 0 1 2 1.142857 -0.198451 3.332205 15.40475 0.7621401 -0.1392621 0 -0.0591889 0 0.0363677 0.063179 9.852194 0.0540667 0 -1.52381 -0.5371429
1989 410626 30 5600000 21000 0.71 32 1 0 1 0 6 6.4 -0.3424903 3.401197 15.53828 2.00148 -0.198451 0 -0.1440394 0 0.0689929 0.1335316 9.952278 0.1000843 0 5.257143 1.23934
1987 410627 25 2900000 21830 1 0 0 0 25 3.218876 14.88022 0 0 9.99104
1988 410627 25 2800000 22454 1 0 0 1 25 3.218876 14.84513 0 0 0 -0.0350914 10.01922 0.0281839 0
1989 410627 25 2900000 23078 1 0 1 0 25 3.218876 14.88022 0 0 0 0.0350914 10.04663 0.0274105 0
1987 410629 16 1100000 18500 1.2 0.58 0 0 0 0 16 0.1823216 2.772589 13.91082 -0.5447272 0 0 9.825526
1988 410629 19 2050000 21000 0.53 0.25 0 0 0 1 19 -0.6348783 2.944439 14.53335 -1.386294 0.1823216 0 -0.8171999 0 0.1718502 0.622529 9.952278 0.1267519 0
1989 410629 23 2260000 23500 0.49 0.36 0 0 1 0 23 -0.7133499 3.135494 14.63088 -1.021651 -0.6348783 0 -0.0784715 0 0.1910553 0.0975256 10.06476 0.1124773 0
1987 410635 100 2.00E+07 22000 0 1 0 0 0 0 0 4.60517 16.81124 0 0 0 9.998797
1988 410635 95 1.80E+07 22000 1 1 0 0 1 1 0.0105263 4.553877 16.70588 0.0104713 0 0 -0.0512934 -0.10536 9.998797 0 0 0.0105263 0.0104713
1989 410635 85 1.60E+07 22000 20 1 0 1 0 50 11.76471 4.442651 16.5881 2.546684 0 0 -0.1112256 -0.1177845 9.998797 0 0 11.75418 2.536213
1987 410636 8 386807 14110 0 0 0 0 8 2.079442 12.86568 0 0 9.554639
1988 410636 10 734613 14040 0 0 0 1 10 2.302585 13.5071 0 0 0.2231436 0.6414185 9.549665 -0.0049734 0
1989 410636 8 518842 14126 0 0 1 0 8 2.079442 13.15935 0 0 -0.2231436 -0.3477449 9.555773 0.0061073 0
1987 410639 135 1.40E+07 20384 1 1 0 0 0 50 0.3703704 4.905275 16.45457 0.315081 0 0 9.922505
1988 410639 135 1.50E+07 20800 3 1 0 0 1 75 1.666667 4.905275 16.52356 0.9808292 0 0 0 0.0689945 9.942708 0.0202026 0 1.296296 0.6657482
1989 410639 144 1.55E+07 20592 5 1 0 1 0 100 3.472222 4.969813 16.55635 1.497885 0 0 0.0645385 0.0327892 9.932658 -0.0100498 0 1.805556 0.5170562
1987 410640 13 1656000 19266 240 0 0 0 0 3 55.38462 2.564949 14.31992 4.032197 0 0 9.866097
1988 410640 11 1527000 20867 200 0 0 0 1 2 36.36364 2.397895 14.23882 3.620698 0 0 -0.1670539 -0.0811005 9.945924 0.0798264 0 -19.02098 -0.4114985
1989 410640 13 1454000 25154 200 0 0 1 0 2 30.76923 2.564949 14.18983 3.458498 0 0 0.1670539 -0.0489864 10.13277 0.1868486 0 -5.594406 -0.1621997
1987 410641 3600000 0 0 0 0 15.09644 0 0
1988 410641 3900000 0 0 0 1 15.17649 0 0 0.0800428 0
1989 410641 5200000 0 0 1 0 15.46417 0 0 0.2876825 0
1987 410642 0 0 0 0 0 0 0 0
1988 410642 45 0 0 0 1 25 0 0 0
1989 410642 45 0 0 1 0 25 0 0 0
1987 410649 30 2100000 25500 0 0 0 0 30 3.401197 14.55745 0 0 10.14643
1988 410649 27 2252000 26000 0 0 0 1 27 3.295837 14.62733 0 0 -0.1053605 0.0698814 10.16585 0.0194178 0
1989 410649 24 1866064 28000 0 0 1 0 24 3.178054 14.43934 0 0 -0.1177831 -0.1879873 10.23996 0.0741081 0
1987 410653 14 1950000 16000 1.06 1 0 0 0 14 0.0582689 2.639057 14.48334 0 0 9.680344
1988 410653 13 1850000 17000 1.03 1 0 0 1 13 0.0295588 2.564949 14.4307 0.0582689 0 -0.0287101 0 -0.0741081 -0.0526438 9.740969 0.0606251 0
1989 410653 12 1550000 18000 1.14 1 0 1 0 12 0.1310282 2.484907 14.25377 0.0295588 0 0.1014695 0 -0.0800426 -0.1769314 9.798127 0.0571585 0
1987 410665 0.05 0.06 0 0 0 0 0 0 -2.995732 -2.813411 0 0
1988 410665 12 1000000 29120 0.08 0.03 16 0 0 0 1 2 2.666667 -2.525729 2.484907 13.81551 -3.506558 1.299283 -2.995732 0 0.4700036 0 10.27918 0
1989 410665 14 1200000 29120 0.03 0.09 16 0 0 1 0 4 4.571429 -3.506558 2.639057 13.99783 -2.407946 1.717651 -2.525729 0 -0.9808292 0 0.1541507 0.1823215 10.27918 0 0 1.904762 0.4183685
1987 410679 30 26000 3 0 0 0 0 30 3.401197 1.098612 0 0 10.16585
1988 410679 30 26000 3 0 0 0 1 30 3.401197 1.098612 0 0 0 10.16585 0 0
1989 410679 28 27000 3 0 0 1 0 28 3.332205 1.098612 0 0 -0.0689929 10.20359 0.0377407 0
1987 410680 27 2873000 19762 100 0 0 0 0 14 51.85185 3.295837 14.87087 3.967493 0 0 9.891516
1988 410680 61 6097000 21120 50 0 0 0 1 5 4.098361 4.110874 15.62331 1.628919 0 0 0.8150368 0.7524395 9.957975 0.0664597 0 -47.75349 -2.338574
1989 410680 52 5670000 22360 70 0 0 1 0 9 12.11539 3.951244 15.5507 2.573786 0 0 -0.1596301 -0.072608 10.01503 0.0570536 0 8.017025 0.944867
1987 410685 24 2213235 20004 0.14 0 0 0 0 24 -1.966113 3.178054 14.60997 0 0 9.903687
1988 410685 20 2100943 19078 0.16 0 0 0 1 20 -1.832582 2.995732 14.5579 -1.966113 0 0.1335313 0 -0.1823215 -0.0520697 9.856291 -0.0473967 0
1989 41