Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a random sample?
Im a uni student and i have a worksheet with 474 data entries. I need to
create a random sample and i have no idea how to do it. I have instructions for excel 2003, but i have excel 2007. Please help asap!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a random sample?
Try the following formula, substituting the $A:$A with the column letter of
the column that has your data, and the range $A2:$A397 with the range in column A that contains the values you want to sample. =INDEX($A:$A,RANDBETWEEN(1,COUNTA($A2:$A397)),RAND BETWEEN(1,1)) Copy the formula down x number of rows based on the number of samples you want, where 10 samples = 10 rows. Hope this helps. -- Kevin Backmann "Confused student" wrote: Im a uni student and i have a worksheet with 474 data entries. I need to create a random sample and i have no idea how to do it. I have instructions for excel 2003, but i have excel 2007. Please help asap!!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a random sample?
I add a helper column with the Rand() function in each cell. It puts a
random number in each cell. I then sort by that column and take the top ten percent or whatever I need for the sampling. "Confused student" wrote: Im a uni student and i have a worksheet with 474 data entries. I need to create a random sample and i have no idea how to do it. I have instructions for excel 2003, but i have excel 2007. Please help asap!!!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a random sample?
In my other post I forgot to mention that you press the F9 key whenever you
want to refresh your random sampling of values -- Kevin Backmann "Confused student" wrote: Im a uni student and i have a worksheet with 474 data entries. I need to create a random sample and i have no idea how to do it. I have instructions for excel 2003, but i have excel 2007. Please help asap!!!!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make a random sample?
On Apr 25, 9:56*am, Confused student <Confused student
@discussions.microsoft.com wrote: Im a uni student and i have a worksheet with 474 data entries. I need to create a random sample and i have no idea how to do it. I have instructions for excel 2003, but i have excel 2007. Please help asap!!!!! There are several ways you can do it. I have a Black Belt in Lean Six Sigma and when I am under the gun and do nto want to run a chunk of code in VBA I will use =RandBetween(1,1000). I will copy down next to the data column. Then I will copy all of the randbetweens and pasteSpecial as Values. Then sort asending based on the randbetween column. Your top 40 are your samples. If it is a large data set, I will always do it in VBA. then you cen ask it not to have any reapeating numbers. Hope this helps, Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How could I get a random sample from an Excel Sheet | Excel Worksheet Functions | |||
Select a random sample | Excel Discussion (Misc queries) | |||
random sample | Excel Worksheet Functions | |||
Random Sample Without Duplication | Excel Discussion (Misc queries) | |||
How do I create a random sample from a list? | Excel Worksheet Functions |