How can I make the rows go into a random order?
 

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?

How can I make the rows go into a random order?
 

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?

How can I make the rows go into a random order?
 

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?

How can I make the rows go into a random order?
 

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?

How can I make the rows go into a random order?
 

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.

[quote=David J. Braden]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?

Hi! Dave!
This is not related to the issue above. Hi! Dave, this is Janice Blanks from St.Louis. I was wondering if we could get in contact. Please let me know. It has been a long time since we have talked. And, we have a lot to talk about. I hope you are doing well. Hope to talk soon.

Please keep response(s) solely within this thread.[]

[quote=Janice Blanks]Hi! Dave!
This is not related to the issue above. Hi! Dave, this is Janice Blanks from St.Louis. I was wondering if we could get in contact. Please let me know. It has been a long time since we have talked. And, we have a lot to talk about. I hope you are doing well. Hope to talk soon.