How to Do Stratified Sampling in Excel, Step by Step

The most widely used sampling method, demonstrated in Excel with pivot tables: grouping a customer population by customer, document date and amount, choosing samples from each group, and when random or systematic sampling is enough.

7 min video · Module: Module 5: Planning and Executing an Internal Audit · ₹99 / $0.99 · 2 views within 7 days

Included with this video

Previous: How to Choose an Audit Sample: Sample Size, Materiality, Random and Systematic Sampling
Next: Non-Probability Sampling and the Sampling Steps at a Glance

All videos


Checklists, templates and sample documents · Free articles and guides · YouTube

Learn Internal Audit is run by SKYBOT Technology LLP. The founders, Amit Salla and Zehra Maccawala, are partners at ZMAS and Associates, a Chartered Accountancy firm specialising in internal audit.