LINK to data : https://docs.google.com/spreadsheets/d/16LS5eveBMwESQ2Ey6ldS4p9AYxHe3l3HfEA9V7UWfZ0/edit?usp=sharing

1. Using the General Social Survey, calculate Pearson's r and conduct a test to determine if Age your first child was born (AGEKDBRN) is related to the number of children you have (CHILDS).
   1. What is the null hypothesis for this test?
   2. What is the alternative hypothesis for this test?
   3. Use the "Correlation" and "Regression" tools in the Analysis ToolPak to calculate Pearson's r for the correlation between AGEKDBRN and CHILDS, and determine the significance of the relationship.
   4. How many observations are included in the analysis (this is the same as N)?
   5. What is the value of Pearson's r?
   6. What is the value of the t-statistic?
   7. What is the p-value that you get for the t-statistic? (if p < 0.0001, then just report p < 0.0001)
   8. Based on the p-value, what decision do we make about the hypothesis at = 0.05? Use complete sentences to describe the decision you make and why you made it.