» Sample Size Calculator

Sample Size Calculator (spreadsheet)

Version: 2.0

Update: October 2017

Download: Sample Size Calculator v2.0.xls

The Sample Size Calculator consists of six tabs for:

  1. Zα and Zβ.
  2. Means - Single mean (B3, B4), Two-mean comparison (independent and paired) (B1, B2) and standard deviation of difference (B5).
  3. Proportion - Single proportion (C2), two-proportions comparison (independent) (C1), and sensitivity and specificity (C3)
  4. Intraclass correlation coefficient (ICC) (D1).
  5. Kappa coefficient (E1).
  6. Cronbach's alpha coefficient (F1, F2).

The first three tabs (1, 2 and 3) cover only basic sample size formulas; I use these for teaching sample size basics.

In addition, tab 4, 5 and 6 are sample size calculators for three common reliability coefficients. These are very useful for researchers to decide on sample sizes for interrater reliability and scale reliability. I could not find good sample size calculators for these coefficients, and it is quite overwhelming to calculate the sample sizes manually from the formulas provided in the original papers.

The decision to make it accessible in form of spreadsheet file is because the ease of development and cross-platform readability of .xls file. Although the spreadsheet was created in LibreOffice Calc, the .xls should be compatible with other spreadsheet applications.

Please also have a look at the web version of the calculator [ here ].

Suggested reference:

APA: Arifin, W. N. (2017). Sample size calculator (Version 2.0) [Spreadsheet file]. Retrieved from http://wnarifin.github.io

Vancouver: Arifin WN. Sample size calculator (Version 2.0) [Spreadsheet file]. Author: 2017. Available from: http://wnarifin.github.io

Creative Commons License
Sample Size Calculator by Wan Nor Arifin is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

© Wan Nor Arifin 2017-