Part II: Stata Exercise Use Stata to import "NLSY79_small.dta. This dataset contains observations of 1,270 males who were born in 1961, 1962, or 1963. All individuals are at least high school graduates. The following table describes the included variables: Variable Description hispanic 1 if individual is hispanic and 0 if otherwise black 1 if individual is black and 0 if otherwise AFQT Armed Forces Qualification Test score percentile (0 to 100) edu_mom Mother's years of schooling completed edu_dad Father's years of schooling completed college 1 if individual completed college by age 28 and 0 if otherwise earnings Individual's real earnings averaged over 1997, 1999, 2001, and 2003 Use this dataset and Stata to answer the following questions. Make sure to include your Stata code to receive full credit (e.g., Attach a printout of your entire Stata code to the last page). You may find "Tutoriall.do on ICON (go to Files" -> "Stata Tutorial) useful for completing this problem set. For this exercise, we will only use the variables edu_mom, edu_dad, college, and earnings. On Stata command window, type "drop hispanic black AFQT" to remove unnecessary variables. (a) On Stata command window, type "gen college _parent=0. This code generates a new variable called "college_parent" and sets values equal to zero for all individuals in the dataset. Note that the command "gen" is a shorthand for "generate" (b) On Stata command window, type "replace college_parent = 1 if edu_mom >= 14 | edu_dad >= 14. This code tells Stata to replace the value of college_parent with 1 if edu_mom is at least 14 or edu_dad is at least 14. Convince yourself that the variable college_parent coincides with the variable X from Part I. (c) On Stata command window, type "tab college college _parent. This code generates a joint frequency table for college and college_parent. Note that the command "tab" is a shorthand for "tabulate. (d) Using your result from part (c), construct a sample estimate for the joint distribution of college and college_parent (Round all calculations to the second decimal. Your answer should look similar to the joint distribution in Part I). Is an individual whose parent (at least one) completed college less/more likely to complete college than an individual whose parents did not complete college? (e) Compute and report average earnings for individuals who completed college (college equal to 1) and who did not complete college (college equal to 0). Interpret your result 2-3 sentences). Note that in Stata, college == 1 reads college equal to 1. (f) Compute and report average earnings for individuals whose parent (at least one) completed college and whose parents did not complete college. Interpret your result (2-3 sentences). 2 (g) Compute and report average earnings for the four groups of individuals given in the following table. college_parent = 0 college _parent 1 college 0 college = 1 Note that "&" is the "and" operator in Stata. For example, adding if college 0 & college_parent ==0" to a Stata command restricts the sample to those with college equal to 0 and college_parent equal to 0