A spreadsheet template compatible with Microsoft Excel and iWork Numbers that returns the simultaneous confidence intervals for all pairwise differences between multiple sample means.
The objective of the method described in this paper is to develop a spreadsheet template for the purpose of comparing multiple sample means. An initial analysis of variance (ANOVA) test on the data returns F--the test statistic. If F is larger than the critical F value drawn from the F distribution at the appropriate degrees of freedom, convention dictates rejection of the null hypothesis and allows subsequent multiple comparison testing to determine where the inequalities between the sample means lie. A variety of multiple comparison methods are described that return the 95% confidence intervals for differences between means using an inclusive pairwise comparison of the sample means.
Brown
Angus M
AM
School of Biomedical Sciences, Queens Medical Centre, University of Nottingham, Nottingham NG72UH, UK. ambrown@nottingham.ac.uk
D000704:Analysis of Variance; D016001:Confidence Intervals; D003627:Data Interpretation, Statistical; D003628:Database Management Systems; D019992:Databases as Topic; D005240:Feasibility Studies; D006801:Humans