Make a pivot table of Race and Low Birth Weight

Make a pivot table of Race and Low Birth Weight

Question # 00552385 Posted By: rey_writer Updated on: 06/26/2017 02:23 AM Due on: 06/26/2017
Subject Statistics Topic General Statistics Tutorials:
Question
Dot Image
Use Low_Birth_Weight.xls file which consists of data from 189 births. It includes variables regarding the birth weight of the baby, whether it was low weight, the age of the mother, the weight of the mother, the race of the mother, whether the mother smoked, whether the labor was premature, whether the mother had a history of hypertension, and whether the mother had uterine irritability.

  • ASSIGNED PROBLEM 1: Make a pivot table of Race and Low Birth Weight. Then using the JOINT_PROBABILITY.xls file, complete the Joint Probability table so you can answer the following:What is the probability of randomly choosing a Black woman?
  • What is the probability of randomly choosing a White woman AND a Low birth weight?
  • What is the probability of randomly choosing a Black woman OR a Low birth weight?
  • Given that the mother you selected is a White, what is the probability she had Low birth weight?
  • Given that the mother had Low birth weight, what is the probability she is Black?

  • ASSIGNED PROBLEM 2: Let's assume that the Low_Birth_Weight.xls file is a random sample from the Concordia Hospital in 2015. The mean birth weight is approximately 6.5 pounds with a standard deviation of 1.6 pounds. The national standard is that a birth weight below 5.5 pounds is considered to be low. Using the NORMAL_PROBABILITY.xls file, compute the following:What is the probability of a low birth weight (< 5.5 pounds) occurring at Concordia?
  • What is the probability of a birth weight being above the national average of 7.5 pounds?
  • What is the probability of a birth weight being between 5 and 6 pounds?
  • The bottom 10% of births by weight are below what weight?

Expectations: Copy & paste the Excel displays into a Word file if you can. Upload the Word file (or the Excel files) for credit. Comments in which you describe your findings should be included with each display. APA formatting is not required for weekly assignments but adhere to the rules of written English in your punctuation, grammar and spelling.


LowBirthWt BirthWt (pounds)
5.56
5.62
5.63
5.71
5.73
5.78
5.81
5.81
5.87
5.87
6.00
6.02
6.06
6.06
6.10
6.10
6.12
6.13
6.18
6.21
6.24
6.24
6.25
6.31
6.34
6.34
6.40
6.43
6.43
6.43
6.43
6.49
6.49
6.56
6.56
6.56
6.56
6.59
6.62
6.68
6.70
6.74
6.74
6.74
6.78
6.78
6.78
6.81
6.81
6.81
6.83
6.84 LowBirthWt
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No AgeOfMom
19
33
20
21
18
21
22
17
29
26
19
19
22
30
18
18
15
25
20
28
32
31
36
28
25
28
17
29
26
17
17
24
35
25
25
29
19
27
31
33
21
19
23
21
18
18
32
19
24
22
22
23 Page 1 WeightOfMomAtLastMenstrPd
182
155
105
108
107
124
118
103
123
113
95
150
95
107
100
100
98
118
120
120
121
100
202
120
120
167
122
150
168
113
113
90
121
155
125
140
138
124
215
109
185
189
130
160
90
90
132
132
115
85
120
128 LowBirthWt 6.90
6.93
6.99
6.99
7.06
7.06
7.06
7.10
7.10
7.12
7.12
7.12
7.18
7.21
7.21
7.28
7.31
7.31
7.31
7.31
7.34
7.43
7.43
7.49
7.52
7.56
7.59
7.62
7.62
7.65
7.65
7.68
7.81
7.87
7.87
7.90
7.93
7.96
7.96
7.99
7.99
8.01
8.02
8.04
8.04
8.04
8.04
8.15
8.21
8.27
8.30
8.30
8.30 No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No 22
30
19
16
21
30
20
17
17
23
24
28
26
20
24
28
20
22
22
31
23
16
16
18
25
32
20
23
22
32
30
20
23
17
19
23
36
22
24
21
19
25
16
29
29
19
19
30
24
19
24
23
20 Page 2 130
95
115
110
110
153
103
119
119
119
110
140
133
169
115
250
141
158
112
150
115
112
135
229
140
134
121
190
131
170
110
127
123
120
105
130
175
125
133
134
235
95
135
135
154
147
147
137
110
184
110
110
120 LowBirthWt 8.35
8.37
8.43
8.49
8.50
8.50
8.56
8.56
8.62
8.68
8.68
8.68
8.74
8.77
8.80
8.80
8.93
8.93
9.06
9.15
9.18
9.19
9.33
10.12
10.99
1.56
2.25
2.50
2.93
3.25
3.50
3.50
3.75
3.81
3.94
4.00
4.15
4.17
4.18
4.25
4.25
4.25
4.26
4.34
4.53
4.53
4.59
4.59
4.59
4.63
4.68
4.68
4.82 No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes 25
30
22
18
16
32
18
29
33
20
28
14
28
25
16
20
26
21
22
25
31
35
19
24
45
28
29
34
25
25
27
23
24
24
21
32
19
25
16
25
20
21
24
21
20
25
19
19
26
24
17
20
22 Page 3 241
112
169
120
170
186
120
130
117
170
134
135
130
120
95
158
160
115
129
130
120
170
120
116
123
120
130
187
105
85
150
97
128
132
165
105
91
115
130
92
150
200
155
103
125
89
102
112
117
138
130
120
130 LowBirthWt 4.82
4.87
4.90
4.93
4.93
5.03
5.06
5.06
5.07
5.12
5.18
5.18
5.21
5.24
5.24
5.24
5.28
5.31
5.31
5.32
5.34
5.37
5.38
5.40
5.43
5.43
5.43
5.50
5.50
5.50
5.50 Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes 27
20
17
25
20
18
18
20
21
26
31
15
23
20
24
15
23
30
22
17
23
17
26
20
26
14
28
14
23
17
21 Page 4 130
80
110
105
109
148
110
121
100
96
102
110
187
122
105
115
120
142
130
120
110
120
154
105
190
101
95
100
94
142
130 LowBirthWt Race
Black
Other
White
White
White
Other
White
Other
White
White
Other
Other
Other
Other
White
White
Black
White
Other
White
Other
White
White
Other
Other
White
White
White
Black
Black
Black
White
Black
White
Black
White
White
White
White
White
Black
White
Black
White
White
White
White
Other
White
Other
White
Other SmokedAtPreg
No
No
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
No
No
Yes
Yes
No
Yes
No
Yes
No
No
No
No
No
No
Yes
No
Yes
No
No
Yes
Yes
No
No
Yes
Yes
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
No
No
No
Yes
No
No PrematureLabor
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No Page 5 HistoryOfHypertension
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No LowBirthWt White
White
Other
Other
Other
Other
Other
Other
Other
Other
Other
White
Other
Other
Other
Other
White
Black
White
Other
Other
Black
White
Black
White
White
Black
White
White
White
Other
Other
Other
Other
Other
White
White
White
White
Other
White
White
White
White
White
White
White
White
White
White
Other
White
Other Yes
Yes
No
No
Yes
No
No
No
No
No
No
No
Yes
No
No
Yes
No
No
Yes
Yes
Yes
No
Yes
No
No
Yes
Yes
No
No
No
No
No
No
Yes
No
No
No
No
No
No
Yes
Yes
Yes
No
No
Yes
Yes
No
No
Yes
No
No
No No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
Yes
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
Yes
No
No
No Page 6 LowBirthWt Black
White
White
White
Black
White
Other
White
White
White
Other
White
Other
White
Other
White
Other
White
White
White
White
White
White
White
White
Other
White
Black
Other
Other
Other
Other
Black
Other
White
White
White
Other
Other
White
White
Black
White
Other
Other
Other
White
White
White
White
Other
Black
White No
No
No
Yes
No
No
No
Yes
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
Yes
No
Yes
No
No
No
No
No
No
Yes
Yes
Yes
No
No
Yes
Yes
No
Yes
No
No
No
No
Yes
Yes
No
Yes
Yes
Yes No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
Yes
No
No
Yes
No
No
No
Yes
No
No
No
Yes
No
No
No
No
No
Yes
No
No
Yes
No
No
Yes
No
Yes
No
Yes Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
Yes
No
No
No
No
Yes
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No Page 7 LowBirthWt Black
Other
White
Other
Other
Other
Black
White
Other
Other
White
White
Black
Black
Black
Other
Other
White
White
White
White
Black
Other
Other
White
Other
White
Other
Other
Black
White No
Yes
Yes
No
No
No
Yes
Yes
No
No
Yes
No
Yes
Yes
Yes
No
No
Yes
Yes
Yes
Yes
No
No
No
Yes
Yes
Yes
No
Yes
No
Yes No
No
No
Yes
No
No
Yes
Yes
Yes
No
Yes
No
No
No
No
No
No
Yes
No
No
Yes
No
Yes
No
No
Yes
No
No
No
No
No No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
Yes
Yes Page 8 LowBirthWt UterineIrritability
Yes
No
No
Yes
Yes
No
No
No
No
No
No
No
No
Yes
No
No
No
No
Yes
No
No
Yes
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
Yes
No
No
No
No
No
No Page 9 LowBirthWt No
No
No
No
Yes
No
No
No
No
No
No
No
No
Yes
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No Page 10 LowBirthWt No
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No
Yes
Yes
No
No
Yes
No
Yes
No
No
No
No
Yes
No
No
No
No
Yes
No
No
Yes
No
No
Yes
No
No
Yes
No
Yes Page 11 LowBirthWt Yes
Yes
No
No
No
No
No
Yes
No
No
No
No
No
No
No
Yes
No
No
No
No
No
No
No
No
No
No
No
No
No
No
No Page 12
Dot Image
Report this Question as Inappropriate
Tutorials for this Question
  1. rey_writer
    Tutorial # 00549721 Posted By: rey_writer Posted on: 06/26/2017 02:23 AM
    Puchased By: 3
    Tutorial Preview
    The solution of Make a pivot table of Race and Low Birth Weight...
      Get the Solution
    Attachments
    10697860.xlsx (26.59 KB)
  Get the Solution

Great! We have found the solution of this question!

Related Questions and Answers

Whatsapp Lisa