kofman_v_week2lab

kofman_v_week2lab - 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: Vitaliy Kofman Part 1. Random Sampling It's important for auditors to randomly select files to audit because it will save time and will give them a good overall idea how most of the files are doing. By using the random sampling, everyone has an equal chance to get selected and you are not discriminating against anyone in particular since Excel does everything for you and everyone has equal chance of being selected. I performed the random sapling by first assigning numbers 1-74 next to each of the account names. Then I activated the analysis toolpak and highlighted numbers 1-74, followed by function to generate 20 random samples. Since I got some duplicate numbers, I performed this action a couple times until all numbers were different. Finally, I copied/pasted results into the ordered pair column and used the "sort ascending" function to organize the data. These are the results: 2 - AB 6 - AE 12 - AL 16 - AP 19 - AR 36 - BJ 38 - BL 40 - BN 43 - BQ 45 - BR 46 - BT 48 - BV 51 - BY 52 - BZ 58 - CF 61 - CI 65 - CM 67 - CO 69 - CQ 71 - CS
Background image of page 1

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

View Full DocumentRight Arrow Icon
Part 2. Cereal and Fiber Type
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.

This note was uploaded on 11/16/2010 for the course MATH 221 taught by Professor Bethdodson during the Fall '10 term at DeVry Chicago.

Page1 / 6

kofman_v_week2lab - 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