Below is a series of 35 individuals in which we have a height and weight measure
ID: 3318159 • Letter: B
Question
Below is a series of 35 individuals in which we have a height and weight measurement. Compute the regression equation using height to predict weight.
Height
Weight
Height
Weight
61
140
65
135
66
120
66
125
68
130
65
118
68
138
65
122
63
121
65
115
70
125
64
102
68
116
67
115
69
145
69
150
69
150
68
110
67
150
63
116
68
125
62
108
66
130
63
95
65.5
120
64
125
66
130
68
133
62
131
62
110
62
120
61.75
108
63
118
62.75
112
67
125
1.) Compute the regression equation using height to predict weight.
2.) For each increase of 1 inch in height, how much of an increase in weight will occur?
3.) For each change of 1 standard deviation of height, weight changes by how much of a standard deviation?
4.) What number indicates the errors in prediction?
Height
Weight
Height
Weight
61
140
65
135
66
120
66
125
68
130
65
118
68
138
65
122
63
121
65
115
70
125
64
102
68
116
67
115
69
145
69
150
69
150
68
110
67
150
63
116
68
125
62
108
66
130
63
95
65.5
120
64
125
66
130
68
133
62
131
62
110
62
120
61.75
108
63
118
62.75
112
67
125
Explanation / Answer
the simple linear regression model is,
y= a+ bx +e ............................regression model
where x- independent variable (height)
y- dependent variable
e-error
the regression analysis in excel is
follow the path
ANOVA
df
SS
MS
F
Significance F
Regression
1
1484.921
1484.921
10.66503
0.002548
Residual
33
4594.679
139.2327
Total
34
6079.6
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Lower 95.0%
Upper 95.0%
Intercept
-44.8589
51.68351
-0.86795
0.391688
-150.01
60.29197
-150.01
60.29197
Height
2.578883
0.789679
3.265735
0.002548
0.972269
4.185497
0.972269
4.185497
1.) Compute the regression equation using height to predict weight.
Y= -44.85 + 2.57 Y ...................PREDICTED MODEL
2.) For each increase of 1 inch in height, how much of an increase in weight will occur?
answer is "2.57"
3.) For each change of 1 standard deviation of height, weight changes by how much of a standard deviation?
answer-: 0.79
4.) What number indicates the errors in prediction?
error in indication is diven in the first table
MSE- 139.23
thanks
ANOVA
df
SS
MS
F
Significance F
Regression
1
1484.921
1484.921
10.66503
0.002548
Residual
33
4594.679
139.2327
Total
34
6079.6
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.