Math 221
Week 6 Lab
Submitted by:
James Rigney
Part 1.
Normal Distributions and Birth Weights in America
Gestation
Period
Mean
Birth
Weight
Standard
Deviatio
n
Under 28
Weeks
1.88
1.19
Answer
28 to 31 Weeks
4.07
1.87
Question
2 a
0.9988
(=NORMDIST(5.5,H3,I3,TRU
E)
32 to 35 Weeks
5.73
1.48
36 Weeks
6.46
1.2
Question
3 a
8.7269
(=NORMINV(0.9,H7,I7))
37 to 39 Weeks
7.33
1.09
40 Weeks
7.72
1.05
Question
4 a
0.4141
(=NORMDIST(9,5.73,1.48,TR
UE)-
NORMDIST(6,5.73,1.48,TRU
E))
41 Weeks
7.83
1.08
42 Weeks and
over
7.65
1.12
Part 2.
Age Distribution in the United States
Answer
Question
1
49.5
Question
2
1.824
Question
3
No. Ages of people decrease as the ages increase -
not just in the US but in all countries.
Question
4
Question
5
30
Question
6

This
** preview**
has intentionally

**sections.**

*blurred***to view the full version.**

*Sign up*Part 3.
Finding z- and t-scores for Confidence Intervals
1.
Using Excel, find the z-score that corresponds to the following Confidence Levels:
a.
80% =
1.28155
b.
85% =
1.43953
c.
92% =
1.75069
d.
97% =
2.17009
2.
Using Excel, find the t-score that corresponds to the following Confidence Levels and

This is the end of the preview.
Sign up
to
access the rest of the document.