E3. Examine the relationship between ideal number of children (CHLDIDEL) and respondent’s number of children (CHILDS). Treat CHLDIDEL as the independent variable and CHILDS as the dependent variable.

1. Write out the regression equation predicting CHILDS with CHLDIDEL.

2. Using the regression equation, if someone’s ideal number of children is five, how many children are they predicted to have?

3. Create a scatter diagram of CHLDIDEL and CHILDS. Impose a regression line on your visual.

4. Have Excel calculate the correlation coefficient for CHLDIDEL and CHILDS. Using the correlation coefficient, describe the relationship between the two variables.