Estimating Sample-Size Requirements with a Handy Calculator
While many programs, apps, and web pages are available to perform power and sample-size calculations, they aren’t always easy or intuitive to use. Because spreadsheets like Excel are readily available and intuitive, it’s convenient to have a single spreadsheet that can perform power and sample-size calculations for the situations that arise most frequently in biological and clinical research.
The Sample Size Calculations spreadsheet gives you a simple way to estimate the sample size you need when designing a study involving the following statistical analyses:
It’s important to realize that most of the calculations in this spreadsheet are only approximations. They’ll usually give sample-size answers that are within a few subjects of the exact answer, which should be adequate when you’re planning a study. But they shouldn’t be taken as the “official” answers.
Before you use the calculator for any of the preceding calculations,