HSC Home Page
University of Utah Health Sciences Center Pediatric Emergency Medicine
  PEM Home Page  


Statistical Calculators

  • Each spreadsheet performs a different statistical calculation
  • Each consists of three (3) worksheets:
    • instructions
    • an example
    • the actual calculator
  • Microsoft Excel 97/98 or higher is required

Available Calculators

File Name [.zip]Calculates the following:
ChiSquar
[Excel format]
Pearson's Chi-squared statistics and p-value given a 2x2 table
CIDiffP
[Excel format]
95% confidence interval for the difference between 2 proportions or rates
CIOR
[Excel format]
odds ratio and 95% confidence interval from logistic regression coefficient and SE
CIProp
[Excel format]
95% confidence interval for a proportion or rate (uses an iterative Excel macro)
PowerM
[Excel format]
power for comparison of 2 means (eg, t-test) with equal sample size
PowerMne
[Excel format]
power for comparison of 2 means (eg, t-test) with unequal sample size
PowerP
[Excel format]
power for comparison of 2 proportions (eg, Chi-squared test)
SmplSzM
[Excel format]
sample size to compare 2 means (t-test) given alpha, power, sigma, delta (easier)
SSMExact
[Excel format]
sample size for t-test or ANOVA using exact methods, by iteration (more difficult)
SmplSzP
[Excel format]
sample size to detect a specified difference in 2 proportions, given power, n, alpha
SnsSpec
[Excel format]
sensitivity, specificity, and positive and negative predictive values from 2x2 table
Download All Calculators [.zip format]


University of Utah Health Sciences Center
50 North Medical Drive, Salt Lake City, Utah 84132