Stratified sampling is a probability sampling technique that divides a population into smaller subgroups, known as strata, before selecting samples from each stratum. This method allows you to focus your sampling on subsets of your data.

Contents
How Stratified Sampling Works
- Define the population: Clearly identify the group you want to study.
- Choose stratification variables: Select characteristics that divide your population into non-overlapping subgroups (e.g., age, gender, income).
- If there are no subgroups, consider other sampling techniques.
- Divide the population into strata: Create homogeneous subgroups based on the chosen variables.
- Determine sample size: Decide how many samples you need from each stratum.
- Use a technique like this or the Random Sampler add-on.
- Select samples: Use random sampling within each stratum.
Advantages
- Improves representation of minority subgroups
- Increases precision for a given sample size
- Allows for different sampling techniques in different strata
- Enables analysis of inter-strata variations
Types
- Proportionate stratified sampling: The sample size for each stratum is proportional to the stratum’s size in the population.
- Disproportionate stratified sampling: Sample sizes vary based on analytical goals or stratum characteristics.
When to Use Stratified Sampling
- The population has distinct, non-overlapping subgroups, as shown in the example spreadsheet above.
- Subgroup proportions in the population are known
- You need to study specific subgroups in detail
- There’s high variability between subgroups but low variability within them
Limitations
- Requires knowledge of appropriate stratification variables
- It can be complex and time-consuming
- It may be challenging if population members belong to multiple strata
Video Tutorial
Conclusion
Stratified sampling is a valuable technique to find an accurate representation of diverse populations. By understanding its principles and applications, you can leverage this method to enhance the validity and reliability of your studies across various fields, from social sciences to market research.
Related Articles
-
Choosing the Appropriate Sampling Method for Spreadsheet Data
Learn how to use a flowchart decision making process to decide on a sampling method for data in your spreadsheet.
-
Conditionally Find the Smallest Value | Google Sheets
Learn how to find the smallest value in a dataset depending on other values.
-
How to Choose Between Simple, Systematic, and Stratified Sampling
Learn how to choose which sampling method works best for your spreadsheet data.

