Math 221
Week 2 Lab
Submitted by:
Part 1.
Random Sampling
Ordere
d
Sample
Account
Name
3
ac
5
ae
6
af
7
ag
8
ah
9
ai
17
aq
21
au
31
be
56
cd
35
bi
38
bl
72
ct
52
bz
60
ch
19
as
61
ci
68
cp
70
cr
71
cs
1. It is important to randomly sample these accounts to insure that all these
accounts have equal chance to be checked for accuracy.
2. I used the “RandBetween” function in excel to generate the 20 random
samples from the 74 accounts.
Part 2.
Cereal and Fiber Type
I used the chart function in excel to create the bar chart.
This preview has intentionally blurred sections. Sign up to view the full version.
View Full DocumentI used the pie chart function in excel to create the pie chart.
Part 3.
Milk Production
1.
Find the sample mean.
The sample mean is 2270.55 and I used the average function to in excel to determine the
mean. (
=AVERAGE(A2:A51)
)
2.
Find the sample standard deviation.
The sample standard deviation is 6351.18 and I used the stdev function in excel to
determine the standard deviation. (
=STDEV(A2:A51)
)
3.
Make a frequency distribution for the data.
Distribution is started at right.
Milk Production
This is the end of the preview.
Sign up
to
access the rest of the document.
 Spring '10
 BethDodson
 Math, Statistics, Standard Deviation, standard deviations

Click to edit the document details