How to select my random sample from a population?
This document provides you a step-by-step guide to draw randomly your sample from a large population as
required for Assignment 1.
Step 1: Data Data AnalysisRandom Number Generation OK
Step 2: Enter the details as shown in the box below and 2000 random numbers would be generated in
Column A. Please note that you would have data on different variables in the columns after Household
ID.
Step 3: After you generate the random numbers, now right click anywhere on the sheet and then
choose sort custom sort from the drop down menu.
Number of variables = 1
Number of Random Numbers = 2000
Distribution: Uniform
Between: 0 and 10
Random Seed: Last four digits of your student ID
18191503
Output Range: A2
Press OK
Choose Rand in sort by and rest of the options as shown in the following picture. Then press Ok.
This will sort the data on Rand whilst shuffling corresponding household data as shown below.
Step 4: Now you can select data for the first 250 households. Copy this information (all variables) and
paste on sheet 2 of this Excel file. This completes your sample selection.
Prepared by: Dr. Saqib Manzoor
Rand
Household
IDIncome ATaxInc Grocery Alcohol Meals Fuel Cloth Phone Utilities Texp Children Adults Ownhouse
Highest
Degree GHH
0.013428 H1560 85228 70026 8690 348 0 2000 800 720 300 16144 0 3 1 S F
0.019227 H0606 120407 106445 7821 782 1800 540 960 660 1700 39115 0 2 1 B F
0.02411 H0365 28000 26362 13035 1043 1800 2100 900 1200 310 22933 0 2 1 M M
0.030213 H0805 110000 83042 7039 2086 3000 1980 900 1020 845 28177 0 2 1 S F
0.034181 H1630 41580 37145 7821 2607 2400 0 840 420 1400 26909 0 2 1 S M
