This macro will perform a variation of an approximate randomization test. It is used to compare two groups of average values. Instead of just using the difference between the two means of the values, we use a t test to determine the difference between the two groups. For the moment, you need to have equal numbers of values in the two columns. The randomizations will take place, and you will be given a p value, based on the number of randomizations carried out.
Windows 98, NT4, ME, 2000
Runs in Excel 98 and 2000.
This macro has been developed by David Cox.
Please use the tools available at The Macroshack at bioinformatics.org
for comments, suggestions, and bugs.
Download the macro.
Instructions on using the macro.
Back to the program list.
This page was last updated on: November 08, 2002 by David G. Cox