Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 43
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 410
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How could I get a random sample from an Excel Sheet SAZFFXCTY Excel Worksheet Functions 0 March 8th 07 08:44 PM
Select a random sample IPMS Excel Discussion (Misc queries) 2 January 7th 07 03:54 AM
random sample skimpw Excel Worksheet Functions 0 August 15th 06 01:15 AM
Random Sample Without Duplication beccadawn0622 Excel Discussion (Misc queries) 3 January 25th 06 03:13 PM
How do I create a random sample from a list? swrath Excel Worksheet Functions 1 December 23rd 05 04:32 PM


All times are GMT +1. The time now is 04:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"