How it works
The number of items per parameter sampling methodology allows you to select a number of transactions for each classification of an item in your dataset. The Sampling Tool will then randomly select that number of items for each class.
To select samples, simply follow these steps:
Step 1
Ensure that there is an appropriate parameter to be used in the dataset. This would be a Column with a classification for each transaction.
Step 2
In the Analysing and Sampling group, click on Sampling Tool and click on ‘# per Parameter’.
A new pop-up window will appear.
Step 3
Step 4
From the Parameter column dropdown, select the heading/column applicable.
Step 5
Populate the number of items to be selected for each parameter.
Step 6
To further stratify your population or include all material items over and above the sample size.
Click below to view the Sampling Advance Section Guidance Page.
Step 7
Select whether you would like the selected items to be highlighted in the original dataset
Also select whether you would like the resulting sample to be emailed?
If email is selected, upon completion of executing the sample selection, a new email will be populated containing the sample ready to be sent to whomever.
Step 8
Click ‘Continue’.
Step 9
The sample will be selected and populated into a new sheet in the active workbook.
