In Microsoft Excel, install the Analysis ToolPak add-in to gain access to a large collection of data-analysis tools, including t-tests and several analysis of variance tests. The single factor ANOVA function takes several data columns as arguments and generates analysis of variance data on the same spreadsheet or a new one. Writer Bio
