Model Building with Stepwise Regression
Trying the Simulation Approach in Statistical Analysis
Two Views of Probability

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:

Click here for two-group (unpaired) comparison of means by the Student t test.

Click here for two-group (paired) comparison by the Student t test.

Click here for comparison of two observed proportions by the chi-square or Fisher Exact test.

Click here for comparison of one observed proportion versus a fixed proportion value.

Click here for test for correlation coefficient = 0.

Click here for one-way ANOVA for balanced (equal-sized) groups.

Click here for comparison of two event rates.

Click here for survival analysis by log-rank or Cox proportional-hazards regression.

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,

Click here for a few basic instructions and concepts.

blog comments powered by Disqus
10 Names Every Biostatistician Should Know
Biostatistics For Dummies Cheat Sheet
The Bootstrap Method for Standard Errors and Confidence Intervals
Advertisement

Inside Dummies.com