Scribd
Upload
126 views14 pages

Excel Guide to Random Sampling Techniques

There are two steps to random sampling: determining sample size and selecting sample elements. Sample size is calculated using a formula that divides the population size by 1 plus the margin of error squared. This formula is programmed in Excel. To select sample elements, the Analysis Toolpak must be used. Numbers are randomly selected from a range containing the population coded from 1 to the population size. The randomly selected numbers are output to another range.

Uploaded by

Chris Mine
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
126 views14 pages

Excel Guide to Random Sampling Techniques

There are two steps to random sampling: determining sample size and selecting sample elements. Sample size is calculated using a formula that divides the population size by 1 plus the margin of error squared. This formula is programmed in Excel. To select sample elements, the Analysis Toolpak must be used. Numbers are randomly selected from a range containing the population coded from 1 to the population size. The randomly selected numbers are output to another range.

Uploaded by

Chris Mine
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Sampling

There are two steps involved in random sampling:


sample size calculation and sample elements selection

In sample size calculation, this the generally used formula

n = ____N____
1 + Ne2

Where n is the sample size, N is the population size and e


is the margin of error, assumed to be 0.05 for business
studies.

We shall program this I Excel.


n = ____N____
1 + Ne2
Type as illustrated
Type in B1, 1000
In B2, =A2
In B3, 0.05
In B4, =B3^2
In B5, =B1*B4
In B6, =B2+B5
In B7, B1/B6
In sample elements selection you must use Analysis
Toolpak

Click File
Click Options
Click Add-ins
Click Analysis Toolpak
Click Go
Check Analysis Toolpak
Click OK
Open a new Excel sheet. Click Data
Click Data Analysis
Scroll the box , select Sampling and click OK.
Open a new Excel sheet.
Assume population size of 100. Sample size is 80.
Assume 100 respondents, coded from 1 to [Link] the
codes 1 to 100 starting at A1 and ending at A100. The
computer will randomly select 80 numbers.
Click Data, click Data Analysis, click Sampling, click OK.
Type in input range box, A1:A100
Type in number of samples, 80
Click Output range and type D1.

Click OK.
If there are numbers repeated, repeat the process with
C1 as output range.

You might also like