Statistics for everyone: Excel and Statistics(15), Sampling

Excel and Statistics, everybody should know. : Contents

Sampling

Let’s open the ‘Sampling’ window.

Using ‘filter.xlsx’, select a range(only for numeric variable), and try to extract only 20 of them.

As a result, 20 numbers will be randomly drawn each time. On the other hand, it does not have to contain characters at this time, and since you cannot select multiple columns at the same time, there are many limitations, so let’s look at additional methods.

Plus Alpha

In the empty column, enter =RAND() on row 2Œ. This function randomly fills the rational numbers ‘from 0 to 1’. Then double-click the square in the lower right corner.

This will populate the same function all the way down.

Click one of the numbers, then select ‘Data> Sort’. If you select the column where you put ther andom function in the ‘sort by’ and check OK,

The result is a random mix. So you can choose as many numbers as you want from the top. Each time, a different one will be chosen.

Let's say we need to extract 1 out of 3 people in a periodic way. First, fill column F with the numbers 1 through 3. Double-click the small square in the lower right corner.

Change it to ‘Copy Cells’. In some cases, ‘Copy Cells’ are automatically assigned.

Then the same number appears repeatedly.

Again, we use sort as we learned earlier.

If you choose only 1, you will periodically choose 1 out of 3 people.

Excel and Statistics, everybody should know. : Contents

=================================================