This Microsoft Excel random sample selector will copy a random sample of data from a given source and include it in a separate worksheet.
The Random Sample Selector features the following:
- Preserve original source data in a separate file (allows for audit trail)
- Define the size of your sample to be selected
- Quickly isolates samples in a separate worksheet
- Can handle data sets as large as there are rows in your worksheet
- Easy to use
This toolbar will quickly select a sample from the data set you provide, and isolate the sample in a separate worksheet. Once isolated, the sample can be used to perform audit tests, or other analysis as needed. The Random Sample Selector works with Excel 97-2003, Excel 2007, and Excel 2010.
This is a useful tool for auditing firms looking to improve their audit efficiency through standardized work papers. Scientists and statisticians can also benefit from quickly generating random samples.
Of course if there are ever any problems with the add-in or if you have any questions, we will always be happy to assist you. Click here to contact us.