The spreadsheet “Total Fertility Rates and Income-S2020.xlxs” on Canvas contains data on total fertility rates (TFR, expected number of children born per woman entering her child-bearing years) and per-capita income (GNP, thousands of US$, adjusted for purchasing power) for a sample of countries for which these data were available both in 1980 and 2009.
Research in the economics of the family hypothesizes that the demand for children decreases with income. As countries become richer, the value of people’s time increases. Children are a very time-intensive “commodity.” Thus, we’d expect total fertility rates to decrease as countries’ per-capita incomes rise. In addition, people in richer countries do not depend on their children for support in old age—pensions and social security reduce the “asset demand for children.”
Please answer the following questions in the space provided here and submit your assignment (both this Word document and your Excel spreadsheet with data and calculations)
Derive summary statistics on the TFR and GNP using the “Total Fertility Rates and Income” data.
What is the mean TFR in 1980?
What is the mean TFR in 2009?
Is the mean TFR significantly different between the two years? Use a test of the difference between means at the p=.05 significance level to answer this last question, and state your test statistic.
Consider the following simple OLS regression model:
Now estimate the simple OLS regression model in Question 2, USING EXCEL(the excel spreadsheet we used for the API and FLE model would be a good template for doing this), and use it to answer the following questions:
Over time, other things that affect fertility may change. For example, women become more educated, and this may have an effect on women’s willingness to have children that is independent of income. Does knowing this change the way you feel about the reliability of your OLS estimates? Why or why not?
How might you use the “year” variable to control for other variables that might be affecting fertility over time? Please write the equation of the model only.
Using EXCEL, please estimate a multiple regression model that controls for changes in fertility over time, independent of income. (That is, add a year variable to your model.)
Report the estimated coefficient on your time variable, and explain what it means.
Is your econometric estimate of the effect of income on fertility unchanged? Why or why not?
Which does a better job of explaining the variation in total fertility around the world mean, the simple or multiple regression model? Explain.