week2laba.jasperstat

week2laba.jasperstat - Math 221 Week 2 Lab Submitted by...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
I 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
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 4

week2laba.jasperstat - Math 221 Week 2 Lab Submitted by...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online