Please Show how to do in excel!!! Birth Length (in) of Newborn Infants Height of
ID: 3134507 • Letter: P
Question
Please Show how to do in excel!!!
Birth Length (in) of Newborn Infants
Height of Mother (in)
Height of Father (in)
Birth Weight of Nearest Sibling (lb)
1
22.0
61
70
6.5
2
23.5
64
72
6.1
3
24.0
64
74
7.3
4
24.7
59
71
5.8
5
18.7
59
60
5.9
6
22.1
64
62
6.7
7
23.0
62
73
6.8
8
24.3
64
76
7.2
9
22.3
66
74
5.9
10
22.1
65
72
6.1
11
20.3
63
71
6
12
24.2
64
76
7.4
13
21.9
65
72
6.2
14
23.4
62
78
6.7
15
26.1
64
77
7.1
16
22.5
63
72
6.8
17
21.1
61
73
6.5
18
22.6
63
69
6.7
19
21.9
63
68
6.2
20
19.6
60
61
5.9
21
19.6
61
64
5.8
22
22.5
64
66
6.2
23
21.6
65
73
6.5
24
24.1
66
72
7.1
25
22.8
63
68
7.1
Scenario 5: Perform a multiple linear regression analysis to predict a newborn’s birth length (in inches) using the father’s height (X1) and the birth weight of the nearest sibling (X2) as the predictor variables. Conduct your analysis using a 95% level of confidence.
Question 22: Does the regression model confirm a correlation between the dependent variable and the independent variables? How do you know? (5 points)
Question 23: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points)
Question 24: What is the value of F associated with this regression model? (5 points)
Question 25: What is the regression equation for the model? (5 points)
Question 26: Are both independent variables in this model significant? How do you know? (5 points)
Question 27: What is the predicted birth length of a newborn whose father’s height of 73.6 inches tall and the nearest sibling’s birth weight is 6.25 lbs? (5 points)
Birth Length (in) of Newborn Infants
Height of Mother (in)
Height of Father (in)
Birth Weight of Nearest Sibling (lb)
1
22.0
61
70
6.5
2
23.5
64
72
6.1
3
24.0
64
74
7.3
4
24.7
59
71
5.8
5
18.7
59
60
5.9
6
22.1
64
62
6.7
7
23.0
62
73
6.8
8
24.3
64
76
7.2
9
22.3
66
74
5.9
10
22.1
65
72
6.1
11
20.3
63
71
6
12
24.2
64
76
7.4
13
21.9
65
72
6.2
14
23.4
62
78
6.7
15
26.1
64
77
7.1
16
22.5
63
72
6.8
17
21.1
61
73
6.5
18
22.6
63
69
6.7
19
21.9
63
68
6.2
20
19.6
60
61
5.9
21
19.6
61
64
5.8
22
22.5
64
66
6.2
23
21.6
65
73
6.5
24
24.1
66
72
7.1
25
22.8
63
68
7.1
Explanation / Answer
Question 22: Does the regression model confirm a correlation between the dependent variable and the independent variables? How do you know? (5 points)
yes the regression model confirm a correlation between the variables
Question 23: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points)
Yes this is statistical significant
Question 24: What is the value of F associated with this regression model? (5 points)
F = 2.54
Question 25: What is the regression equation for the model? (5 points)
Y = 2.51 + 2.1x1 - 0.5484x2
Question 27: What is the predicted birth length of a newborn whose father’s height of 73.6 inches tall and the nearest sibling’s birth weight is 6.25 lbs? (5 points)
Y = 23
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.