MacroChris
New Member
- Joined
- Mar 26, 2002
- Messages
- 4
This is a variation on other randon sampling techniques...
I have a worksheet with the entire population in Worksheet("SegmentA"), with around 1,000 rows. I have already calculated for the statistically valid sample size "n" and it is in Worksheet("Stats").
Now, if n=70, how can I generate a subset of
Worksheet("SegmentA") with only 70 records instead of 1,000?
The sample data can also be pasted in the same Worksheet("SegmentA"), like in Column R.
Please? Anyone?
Thanks,
Christina
I have a worksheet with the entire population in Worksheet("SegmentA"), with around 1,000 rows. I have already calculated for the statistically valid sample size "n" and it is in Worksheet("Stats").
Now, if n=70, how can I generate a subset of
Worksheet("SegmentA") with only 70 records instead of 1,000?
The sample data can also be pasted in the same Worksheet("SegmentA"), like in Column R.
Please? Anyone?
Thanks,
Christina