Welcome to the web
page of  Peter Nagy

Click here to edit subtitle

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: