How to Create a One Way ANOVA in Excel

Written by shawn mcclain
  • Share
  • Tweet
  • Share
  • Email

If you need to determine whether variations in a group of results are because of a significant change in variables or random chance, you need to perform an analysis of variance (ANOVA). You use a one-way ANOVA when there is only one variable affecting the results. While performing an ANOVA generally requires a number of complicated calculations, Excel 2010 can do all the work for you with the ANOVA tool in the Analysis ToolPak.

Skill level:

Other People Are Reading


  1. 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. 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. 3

    Place a check mark next to "Analysis ToolPak" and click "OK."

  4. 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. 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. 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.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.