Statistics How To

ANOVA Excel 2013 (One-Way ANOVA) Easy Steps and Video

Excel for Statistics > ANOVA Excel 2013 (One-Way)

Watch the video or read the steps below:

ANOVA Excel 2013 : Overview.

With ANOVA (Analysis of Variance), you’re testing different groups to see if there’s a significant difference between them. For example, a manufacturer might have a new process to extend the shelf life of a product. You could use ANOVA to test the “before” and “after” products to see if the average shelf life has been extended. Before you perform ANOVA, you need a null hypothesis. The point of ANOVA isn’t just to test the variance between the groups, it’s also to help you decide if you should support or reject the null hypothesis. In general, if the p-value you get from an ANOVA test is smaller than your alpha level, you should reject the null hypothesis. If your F-value is larger than the f-critical value, that would also lead you to reject the null hypothesis.

anova excel 2013

ANOVA Excel 2013 : Steps.

Step 1: Type your data into columns or rows in Excel. For example, if you are testing three groups of drugs (including a control), type your data into three columns.

Step 2: Click the “Data” tab and then click “Data Analysis.” If you don’t see Data Analysis, load the Data Analysis Toolpak.

Step 3: Click “ANOVA Single Factor” and then click “OK.”

Step 4: Type an input range into the Input Range box. For example, if your data is in cells A1 to C10, type “A1:C10” into the box. Check the “Labels in first row” if you have column headers, and select the Rows radio button if your data is in rows.

Step 5: Select an output range. For example, click the “New Worksheet” radio button.

Step 6: Choose an alpha level. For most hypothesis tests, 0.05 is standard.

Step 7: Click “OK.” The results from ANOVA will appear in the worksheet.

That’s it!

Check out our YouTube channel for more Excel stats tips.


Need help with a specific statistics question? Chegg offers 30 minutes of free tutoring, so you can try them out before committing to a subscription. Click here for more details.

If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.

Comments are now closed for this post. Need to post a correction? Please post a comment on our Facebook page.
ANOVA Excel 2013 (One-Way ANOVA) Easy Steps and Video was last modified: June 14th, 2018 by Stephanie