DFISHER269
New Member
- Joined
- Mar 26, 2002
- Messages
- 1
When I use the data analysis tool in Excel and choose random sample. The return data (requesting 50 out of 68) returns duplicate
data. The input data contains a row numbered 1 to 68. I need unique 50 data samples.
In addition I had to create a col numbered 1 to 68 in order to use the random sample, and then use a vlookup on the output to associate the data that it corresponds to. Otherwise without the numbered col. it gives an error message of, ..."input data contains non numeric data". If I wanted a random sample of names how would this be accomplished?
data. The input data contains a row numbered 1 to 68. I need unique 50 data samples.
In addition I had to create a col numbered 1 to 68 in order to use the random sample, and then use a vlookup on the output to associate the data that it corresponds to. Otherwise without the numbered col. it gives an error message of, ..."input data contains non numeric data". If I wanted a random sample of names how would this be accomplished?