Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
|
|||
|
|||
[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.[] |
#7
|
|||
|
|||
[quote=Janice Blanks]
Quote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make inventory sheet to track, order & reduce quantity from master | Excel Worksheet Functions | |||
Can I make an order form on an office application? | Excel Discussion (Misc queries) | |||
How do I make rows expand to fit wrapped text in cells? | Excel Discussion (Misc queries) | |||
Can you sort text in a random order in Excel | Excel Discussion (Misc queries) | |||
How do I split a column having numbers and text in a random order | Excel Worksheet Functions |