Data Analysis - Random Sampling

R

Roger

I am trying to do a validation of and excel spreedsheet that uses random
sampling. My problem, is I need some sort of calculation or something to go
by, to how excel selected the random numbers. Say I had a set of 1, 2, 3, 4,
and 5. I run a random sample and ask for 1 value, excel spits out 4, how did
it come up with that. Is there any way to figure out what goes on behind the
scenes to come up with that value? Any input would be appreciated.
 
A

Alan

You need to post more detail, formulas, code etc. I don't think anyone will
grasp what you want to achieve from this post,
Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random Sampling 5
HOW-TO make a random selection from a set of data and divide it into sub-team 2
randomly picking up an array element from an array of elements 2
Merging from an Excel file with graphics 1
help on summing a random combination 1
List all tables, including document structure 0
MACRO RUN random percentage and copy of column values 1
select random sample of records in a filtered list 0

Top