Purchase Solution

Performing regression analysis using real data

Not what you're looking for?

Ask Custom Question

There is thought to be a relationship between a persons' educational attainment and the number of children he or she has. The hypothesis is that as one's educational level increases, he or she has fewer children. Investigate this conjecture with 25 cases. Draw from the 2006 GSS file. The following displays educational attainment, in years, and the number of children for each respondent.
Education Children Education Children
16 0 12 2
12 1 12 3
12 3 11 1
6 6 12 2
14 2 11 2
14 2 12 0
16 2 12 2
12 2 12 3
17 2 12 4
12 3 12 1
14 4 14 0
13 0 12 3
12 1
a. Calculate the Pearson correlation coefficient for the two variables. Does its value support the hypothesized relationship?
b. Calculate the least square regression equation using education a predictor variable. What is the value of the slope? b? What is the value of the intercept? a?
c. What is the predicted number of children for a person with a college degree (16 years of education)?
d. Does any respondent actually have this number of children? If so, what is her or his level of education? If not, is this a problem or an indication that the regression equation you calculate is incorrect? Why? or why not?

Purchase this Solution

Solution Summary

The solution gives detailed steps on performing a regression analysis using excel. All analysis is based on excel output such as determining slope, intercept, and correlation coefficient

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.