How to Create a One Way ANOVA in Excel

1. Open the Excel 2010 file where you want to create your one way ANOVA. Enter your data sets into the Excel cells. Separate your data sets by columns with the top cell in each column describing the set.
2. Click the 'File' tab at the top of the screen. Choose 'Options' from the list that appears on the left side of the screen. Select 'Add-Ins' from the left side of the window that appears. Click 'Go' at the bottom of the window.
3. Place a check mark next to 'Analysis ToolPak' and click 'OK.'
4. Click the 'Data' tab at the top of the Excel window. Find the 'Analysis' area and click the 'Data Analysis' button found there. Click on 'Anova: Single Factor' in the pop-up window and click 'OK.'
5. Place your cursor into the 'Input Range' box. Click and hold on the top-left cell in your data sets. Drag your mouse to the bottom-right cell and release the button. If you included the headers in your selected range, click the 'Labels in First Row' box in the ANOVA window.
6. Click the radio button next to 'Output Range' and then place your cursor into the text box next to the radio button. Select a cell on your worksheet where you want the ANOVA information to go. Click 'OK' to create the one-way ANOVA.