Slide 14 of 65
Notes:
Figure B.1 Microsoft Excel’s Data Analysis Sampling Tool
We could also use a spreadsheet package such as Microsoft Excel to assist us in selecting a random sample. Suppose we had a volume of 1000 invoices last week and they were sequentially numbered from 2000-2999. We can create a spreadsheet with 1000 rows with column A containing the number of each invoice.
