Select the two factor without replication tool if you want to perform a two-factor ANOVA and include only one sample for each group of data.Įnter the range of data you want to analyze in the Input Range box. Select the two-factor with replication ANOVA tool if you want to include multiple samples for each group of data. Select the single-factor ANOVA tool to test the hypothesis that means from two or more samples drawn from populations with the same mean are equal. To use the ANOVA tools, follow these steps:Ĭhoose the Tools menu’s Data Analysis command.Įxcel displays the Data Analysis dialog box. You can use analysis of variance to test for the equality of k population means. Excel may prompt you to insert the Microsoft Office 2000 or Excel 2000 CD if it isn’t currently in your CD-ROM drive.Īnalysis of variance depends on three assumptions: that the observations are independent, that the response variable is normally distributed for each population, and that the variance of the response variable is the same for all of the populations.
To install the Analysis ToolPak, choose the Tools menu’s Add-Ins command, select the Analysis ToolPak check box, and click OK. Nelson Leave a Comment This section describes the statistical data analysis tools that come with the Analysis ToolPak.