Random numbers
Random sampling basics
Random sampling sounds academic, but the everyday version is simple: define the full list, give every eligible item a clear chance, then use a random method before you look at the result. That helps when you are checking spreadsheet rows, choosing raffle tickets, picking student work to review, or selecting examples from a long list.
Start with the sample frame
The sample frame is the list you are sampling from. It might be rows 2 to 501 in a spreadsheet, ticket numbers 1 to 250, thirty student names, or a list of support tickets. Most unfair samples fail here, before any random tool is used.
Before drawing, ask:
- Is every eligible entry included?
- Are ineligible entries removed?
- Are duplicates intentional or accidental?
- Can everyone understand what the numbers or names refer to?
Simple random sample
A simple random sample gives every item in the frame the same chance of being picked. If you have 100 numbered rows and you generate one number from 1 to 100, each row has a 1-in-100 chance. If you need five rows, generate five numbers and then inspect those rows.
Use the Random Number Generator for custom ranges, or use common presets from the Random Number Tools hub when the range is already known.
With replacement vs without replacement
With replacement means an item can be picked again after it is selected. Dice rolls and coin flips work this way: each roll or flip is independent.
Without replacement means an item can only appear once in the sample. That is usually what you want when reviewing spreadsheet rows, picking student work, assigning presentation order, or drawing backup winners.
If you need unique results, use a List Shuffler, a No-Repeat Name Picker, or generate numbers one at a time and ignore repeats until you have enough unique values.
A practical spreadsheet method
- Number the rows you want to sample, such as 1 to 500.
- Decide how many rows you need before generating anything.
- Use the Random Number Generator to generate that many row numbers.
- If duplicates are not allowed, redraw duplicates or shuffle a numbered list instead.
- Record the range, sample size and generated numbers if the selection needs to be explained later.
Common sources of bias
- Convenience bias: picking only the rows you can see on screen.
- Missing entries: forgetting late entries, absent students or hidden spreadsheet rows.
- Duplicate confusion: leaving accidental duplicate names in a draw where everyone should have one chance.
- Changing rules after the result: rejecting a result because it feels awkward rather than because it broke a rule.
When sampling needs more than a web tool
Everyday random sampling is useful for low-stakes checks and transparent picks. It is not enough by itself for formal research, regulated audits, legal drawings, clinical decisions or any situation that requires a documented statistical protocol. In those cases, use the required method and keep an audit trail.