I have a large data set, let's say 10,000 line items of animal observations.
There are 3 categories: 1. Species: values can be either Lion, Zebra or Buffalo 2. Age: value can be either Young or Adult 3. Social type: value can be either Alone or Group
The statistics for the whole data set are as follows: Species: Lion (20%), Zebra (40%), Buffalo (40%) Age: Young (30%), Old (70%) Social type: Alone (45%), Group (55%)
I need to perform random stratified sampling of the data set to achieve a sample size of 100 line items.
My sample would need to reflect the statistics of the population.
Is there a way to achieve this without VBA?
Thank you
Aucun commentaire:
Enregistrer un commentaire