In this SPSS assignment, Investigate the relationship between individuals' educational attainment and their income using data from the National Survey of Families and Households (nsfh1a.sav).
1. Analyzing Education and Income Trends
- Task: Use SPSS to calculate average income based on the number of years of school completed.
- Pattern Observation: As education levels increase, average wages rise, indicating a positive linear relationship. The number of observations peaks between 1 to 12 years of education.
Income 1 Wage and Salary Earnings Last Year
|red1 Yearsof Education
|Mean||N||Std . Deviation|
Diagram 1: A summary report for income wage and salary earnings
2. Regression Analysis
Task: Run a regression of income on education.
- Interpretation of Intercept: With zero years of education, average earnings are -$1,135.85.
- Interpretation of Beta Coefficient: Each additional year of education results in an increase of $3,206.04 in average earnings.
3. Predictive Table
|Years of School||Predicted Average Earnings|
Table 1: Predictive table
Assignment 2: Impact of Children on Women's Income
Explore the relationship between the number of children women have and their income, focusing on the variables NUMBERCH and INCOME1.
Filtering Women for Analysis
- Task: Use SPSS code to select women-only for further analysis.
- Validation: Verify the filter by re-running the frequency of FEMALE.
Analyzing Children and Women's Income
- Task: Calculate women's average income based on the number of children they have.
- Pattern Observation: As the number of children increases, the number of observations decreases, and average income tends to decrease.
Task: Run a regression of women's income on the number of children.
- Interpretation of Intercept: With zero children, average earnings are $33,535.30.
- Interpretation of Beta Coefficient: Each additional child results in a decrease of $1,317.41 in average earnings.
Women's Income Table
|Women's Number of Children||Income|
Table 2: Women’s number of children vs. income
These summaries provide a clear and organized presentation of your findings from the data analysis.