Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I randomize ascending data (number values) in excel?
I have number values in ascending order and would like to randomize them and
take a smaller sample. How do I randomize this data? |
#2
|
|||
|
|||
This is only an example, but the concept may help you.
Let's say we want do sample ten numbers randomly (and uniquely) from a distribution of one to one hundred. Enter the numbers one to one hundred in a column. In the next column enter =RAND() and copy down. Sort by the second column; this will jumble the first column. Just take the first ten entries in the first column. They will be randomly picked from the distribution with no repeats. Hope this helps -- Gary''s Student "Christa" wrote: I have number values in ascending order and would like to randomize them and take a smaller sample. How do I randomize this data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
How to omit data in a chart when there are error values? | Charts and Charting in Excel | |||
Multiple worksheet queries | Excel Worksheet Functions | |||
Count number of Unique values | Excel Worksheet Functions | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |