Please Show how to do in excel!!! Birth Length (in) of Newborn Infants Height of
ID: 3134508 • 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 6: Perform a multiple linear regression analysis to predict a newborn’s birth length (in inches) using the mother’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 28: Does the regression model confirm a correlation between the dependent variable and the independent variables? How do you know? (5 points)
Question 29: Is the statistical significance of the model as a whole acceptable for a 95% level of confidence? How do you know? (5 points)
Question 30: What is the value of F associated with this regression model? (5 points)
Question 31: What is the regression equation for the model? (5 points)
Question 32: Are all three independent variables in this model significant? How do you know? (5 points)
Question 33: What is the predicted birth length of a newborn whose mother’s height is 58.5 inches and the nearest sibling’s birth weight is 6.9 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 28: Does the regression model confirm a correlation between the dependent variable and the independent variables? How do you know? (5 points)
yes the regression confirm that has a correlation
Question 29: 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 significance
Question 30: What is the value of F associated with this regression model? (5 points)
F = 2.42
Question 31: What is the regression equation for the model? (5 points)
Y = 2.45 + 1.5x1 + 2.5x2
Question 33: What is the predicted birth length of a newborn whose mother’s height is 58.5 inches and the nearest sibling’s birth weight is 6.9 lbs? (5 points)
Y = 152
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.