Question: LINK to data : https://docs.google.com/spreadsheets/d/16LS5eveBMwESQ2Ey6ldS4p9AYxHe3l3HfEA9V7UWfZ0/edit?usp=sharing Using the General Social Survey, calculate Pearson's r and conduct a test to determine if Age your first child was

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!