Biostatistics Applications
This page provides links to Excel files which contain multiple worksheets that enable you to perform a wide variety of statistical functions and tests. To use these, you must open them and then save them on your local computer.
Generates summary statistics on a continuous variable
Worksheets compute confidence intervals for means, proportions, the mean difference in matched or paired samples, and the difference in means and difference in proportions in two independent samples and accept either raw data or summary statistics.
Worksheets conduct tests of hypothesis for means, proportions, the mean difference in matched or paired samples, and the difference in means and difference in proportions in two independent samples and accept either raw data or summary statistics.
Worksheets conduct analysis of variance tests of equality of k independent means and accept either raw data or summary statistics.
Worksheets conduct the chi-square goodness of fit and chi-square test of independence based on observed frequencies.
Worksheets estimate the sample size(s) required to ensure adequate precision in confidence intervals or high power in tests of hypothesis for means, proportions, the mean difference in matched or paired samples, and the difference in means and difference in proportions in two independent samples.