Explore BrainMass

Performing regression analysis using real data

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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?

© BrainMass Inc. brainmass.com October 25, 2018, 9:11 am ad1c9bdddf

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

See Also This Related BrainMass Solution

Linear Regression Hypothesis Analysis for Real Estate Data Set

See attached data file.

Using the attached Excel numerical data, develop a research question, formulate a hypothesis, and perform a linear regression analysis and hypothesis test on the data. Include raw data tables and the results of computations, using both graphical and tabular methods of displaying data and results.

View Full Posting Details