Question

ou are conducting a study testing whether a child’s age is a good predictor of his or her height. You have collected the following data from a random sample of seven children:

Age (months)	Height (cm)
34	77
50	95
63	109
59	99
53	101
44	102
40	94

Perform a regression of height (dependent variable) on age (independent variable).

What is the Y-intercept of the regression line?

52.81

24.73

59.56

58.37

39.07

What is the slope (beta) of the regression line?

1.52

1.31

0.78

1.44

1.61

The regression model predicts that a 5-year-old child (60 months) would be approximately      tall.

Answer 1

A B C D E Age Height 34 77 95 109 99 101 44 102 4094 Slope 0.782609 Intercept 58.36646

Height 77 95 109 101 102 Slope =SLOPE(D3:09,C3:09) Intercept =INTERCEPT(D3:09,C3:09) 13

1.

58.37

2.

0.78

3.

=0.78*60+58.37=105.17 cm