Regression statistics You are conducting a study testing whether a child\'s age
ID: 3238582 • Letter: R
Question
Regression statistics You 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: Perform a regression of height (dependent variable) on age independent variable). What is the Y-intercept of the regression line? 68.60 60.46 43.73 59.56 59.70 What is the slope (beta) of the regression line? 0.45 1.27 1.31 1.16 0.86 The regression model predicts that a 5-year-old child (60 months) would be approximately tall.Explanation / Answer
Age
Height
34
77
50
95
63
109
59
114
53
101
44
122
40
94
We can use excel in this case. First we copy the data set in excel. Then we go to Data tab, there we find Data Analysis. We select for Regression. Now we select x and y data then click OK,
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.5982847
R Square
0.35794458
Adjusted R Square
0.2295335
Standard Error
13.0755568
Observations
7
ANOVA
df
SS
MS
F
Significance F
Regression
1
476.5776398
476.57764
2.7874897
0.155871783
Residual
5
854.8509317
170.97019
Total
6
1331.428571
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
59.56
25.72636329
2.3152169
0.0684605
-6.569610334
125.6938339
Slope
0.86
0.51524912
1.6695777
0.1558718
-0.464241581
2.184738476
What is the y intercept of the regression line?
Answer: 59.56
What is the slope (beta) of the regression line?
Answer: 0.86
Answer: 111.16 cm
The regression model predicts that a 5-year ild child (60 months) would be approximately 111.16 cm tall.
Calculation:
y^ = 59.56 + 0.86x
= 59.56+(0.86*60)
= 111.16 cm
Age
Height
34
77
50
95
63
109
59
114
53
101
44
122
40
94