A spreadsheet template compatible with Microsoft Excel and iWork Numbers that returns the simultaneous confidence intervals for all pairwise differences between multiple sample means

作者：Brown Angus M^*

来源：Computer Methods and Programs in Biomedicine, 2010, 98(1): 76-82.

DOI：10.1016/j.cmpb.2009.10.001

• Analysis of variance
• F-test
• Post hoc test
• Tukey
• Bonferroni
• Dunn-Sidak
• Scheffe
• Fisher LSD

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.

• 出版日期2010-4