I am doing some statistical work, and I am trying to use a systematic sample,
but the rows of data need to be random. How can I make excel do this?

try rand()

"chicken99" wrote:

> I am doing some statistical work, and I am trying to use a systematic sample,
> but the rows of data need to be random. How can I make excel do this?

rand()

"chicken99" wrote:

> I am doing some statistical work, and I am trying to use a systematic sample,
> but the rows of data need to be random. How can I make excel do this?

Add a Column in you data set with the function =Rand().

Then you can sort by that column.


"chicken99" wrote:

> I am doing some statistical work, and I am trying to use a systematic sample,
> but the rows of data need to be random. How can I make excel do this?

PopTools is an excellent, free add-in that will do just what you want
straight off the shelf. Its prng is superb as well, which may interest
you if you are doing real stat work. See
http://www.cse.csiro.au/poptools/

HTH
Dave Braden

chicken99 wrote:
> I am doing some statistical work, and I am trying to use a systematic sample,
> but the rows of data need to be random. How can I make excel do this?

--
Please keep response(s) solely within this thread.