{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Z_E_week2lab - Math 221 Week 2 Lab Submitted by Eric...

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

View Full Document Right Arrow Icon
Math 221 Week 2 Lab Submitted by: Eric Zakrzewski Part 1. Random Sampling Using the Data Analysis ToolPak I chose Sampling. The input range are the numbers I gave the accounts (1-74). You then input 20 for number of samples and the output range. Once the random selection is made I simply did a sort of smallest number to highest number. Ordere d Sampl e 2 8 14 16 20 25 26 33 36 36 39 39 42 47 48 56 57 58 72 73 Part 2. Cereal and Fiber Type Using the table below I created the two charts with the given data. Fiber Type Frequenc y High Fiber 22 Medium Fiber 29 Low Fiber 33 Total 84 Part 3. Milk Production 1. Find the sample mean. To find the sample mean you input the command =average(data_range) or (A2:A51) = 2270.54 2. Find the sample standard deviation. To find the standard deviation you input the command =stdev(data_range) or (A2:A51) = 653.18 3. Make a frequency distribution for the data. Distribution is started at right. Class Limits Frequency Midpoint Cumula tive Freque ncy 1147 1646 7 1396.5 7
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
1647 2146 15 1896.5 22 2147 2646 13 2396.5 35 2647 3146 11 2896.5 46 3147 3646 3 3396.5 49 3647 4146 0 3896.5 49 4147 4646 1 4396.5 50 4. Create a histogram for the data.
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}