PaulDickman.com

Microsoft Excel macros

A worksheet for calculating the Mantel-Haenszel estimate of the common risk ratio from stratified 2 by 2 tables and a test of homogeneity of the stratum-specific risk ratios.

A macro for estimating Fisher's exact test and other measures of association (RR, OR, RD, Pearson chi-square) for a single 2 by 2 table.

These macros were written in 1994 and 1996 and use the old Excel macro language (not visual basic). They are saved in Excel 97 for Windows format.