Help Required : Random Sampling of Data

[anish.ms]

1. ID 1031 has "National Insurance Company, UAE" in the Quarter column

2. It seems that it's either "Simple" XOR "Stratified". Might be less confusing to use a 2 page MultiPage control, one page for each

3. Better expand on the details of the Stratified sampling, and how each field is used

Thanks Paul for your response!
1. For a testing purpose I mentioned "National Insurance Company, UAE" in Quarter and then forgot to remove
2. Moved into a MultiPage control as you suggested
3. I have explained below the details of Stratified sampling and request your help on this

Stratum Variable : This list box will have the names of the variables in the data range. First row of the range contains the variable names/column headers, then these names appear in this list box.

#Strata : This text box will show the number unique values from the above selected Stratum Variable. And next to this there is an option to view those unique values.

Stratified Random Sampling

Equal from each stratum - On specifying the number of records, it highlights sample with same number of records from each stratum.
For example: if “Quarter” is the selected Stratum Variable and 1 as #Each Records, it will highlight total 4 samples 1 each from each quarters (Q1 to Q4)

Proportional to stratum size - On specifying the number of records (total samples), it shall highlight samples proportionate to total count of each stratum.
For example: if “Quarter” is the selected Stratum Variable and 10 as #Total Records, it will highlight total 10 samples based on each quarter count(Q1 to Q4)

Quarter	Count	Sample Size
Q1	57	2	ROUNDUP(10/301*57,0)
Q2	73	3
Q3	68	3
Q4	103	4
Total	301	12

In this case the total sample size cannot be less than the #Strata. In the above example if the total sample size is 1, there shall be total 4 samples – 1 each from each strata based on the roundup formula.

1. Currently Simple Random Sampling and Stratified Random Sampling with Proportional to stratum size method are working based on the RANDBETWEEN formula in column B. Request your help if this can be done without the support of a column AND

2. Stratified Random Sampling with Proportional to stratum size method is not coded/working

Thanks in advance.