Microsoft Excel Tutorial
Table of Contents
(0:00) Random sample from Excel list?
(0:03) Analysis ToolPak
(0:07) Easier - Select 28 Rows
(0:21) SORTBY RANDARRAY
(0:44) No RANDARRAY? Use RAND
Table of Contents
(0:00) Random sample from Excel list?
(0:03) Analysis ToolPak
(0:07) Easier - Select 28 Rows
(0:21) SORTBY RANDARRAY
(0:44) No RANDARRAY? Use RAND
Transcript of the video:
How do we create a random sample in Excel?
There is an old way.
You can Google this.
Look for Analysis ToolPak.
There's easier methods today, though.
First, count how many items you have: 563.
How many do you want?
Let's say we have to audit 5%, that's about 28.
A little bit of pre work here.
Select 28 rows and three columns.
Equal SORTBY.
Select the range.
What are we going to sort by?
A RANDARRAY of 563 - that's the number of items we have.
Close, Close.
Don't press Enter!
Instead, hold down the Control and Shift keys and then press Enter.
Every time you press F9 you get a different 28 items.
If you don't have RANDARRAY, add a column of =RAND, open paren, close paren.
Double-Click to copy that down.
Sort Data, A-Z.
The 1st 28 are your selection.
There is an old way.
You can Google this.
Look for Analysis ToolPak.
There's easier methods today, though.
First, count how many items you have: 563.
How many do you want?
Let's say we have to audit 5%, that's about 28.
A little bit of pre work here.
Select 28 rows and three columns.
Equal SORTBY.
Select the range.
What are we going to sort by?
A RANDARRAY of 563 - that's the number of items we have.
Close, Close.
Don't press Enter!
Instead, hold down the Control and Shift keys and then press Enter.
Every time you press F9 you get a different 28 items.
If you don't have RANDARRAY, add a column of =RAND, open paren, close paren.
Double-Click to copy that down.
Sort Data, A-Z.
The 1st 28 are your selection.
