Confidentiality, Privacy and Security

Sample Size Determination and Sample Selection

  • 1.  Sample Size Determination and Sample Selection

    Posted 08-19-2020 09:30
    Happy Wed!

    What tools are people using to determine sample sizes for statistically valid audits and what tools are you using to pick the associated number of samples?

    Looking to compare and contrast what folks are using.  For example, if I am auditing 10,000 records at the 95% confidence level with a 5% error rate I use the sample size calculator at which provides me the info I need (see snip below).  Then I use the random generator function in Excel to randomly select the 370 samples needed from the 10,000 records.

    I was a RAT-STATS user for some time but I prefer Excel's flexibility and now use it exclusively for auditing.


    Frank Ruelas
    Compliance Professional
    Posted: 6:29 AM AZ time