Statistics with Excel
It is often overlooked that Excel can perform most statistical
calculations ordinary biologists need. I have created an Excel
macro-enabled workbook which will do all the statistical calculations
you probably need if you are a biologist.
The capabilities of the program include:
- descriptive statistics (mean, SD, SEM, median, mode, skewness, kurtosis)
- normality tests
- calculations with the normal, binomial and Poisson distributions
- z-test, Student's t-tests, Welch test, F test
- ANOVA (1-, 2- and 3-way, repeated-measures ANOVA with one factor)
- Levene's test
- non-parametric tests:Wilcoxon test, sign test, median test, Mann-Whitney test
- chi2 test of independence
- Kolmogorov-Smirnov test
- tests for populations proportions
- Kaplan-Meier logrank test
- linear and polynomial regression with p value estimations, linear regression on ranks (Spearman)
- Deming linear regression (when observations of both the X and Y variables are associated with error)
- general purpose fitting
Download the Excel workbook here:
The workbook requires Excel 2010 or above and the Solver Add-in installed.
n-way ANOVA from summary statistics in Matlab
The Matlab program anovanFromSumStat can perform one-way, two-way, ... n-way ANOVA on the main and interaction effects when only summary statistics (mean, SD and size of each group) is available.
The program runs in four different modes depending on the first argument:
- anovaArray=anovanFromSumStat('gen'): it will generate the array containing the means, SDs and size of each group.
- anovaArray=anovanFromSumStat('regen',anovaArray):it will modify the anovaArray created using the 'gen' option.
- varargout=anovanFromSumStat('calc',anovaArray): it will perform ANOVA with the array created in the previous step.
- anovanFromSumStat('ver'): version of the program is displayed.
Help is available when typing 'help anovanFromSumStat' at the Matlab command prompt.
Download the Matlab P-file here: