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.

------------------------------------------------------------------------------

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 help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!
ANOVA Excel 2013 (One-Way ANOVA) Easy Steps and Video was last modified: January 21st, 2018 by Stephanie

3 thoughts on “ANOVA Excel 2013 (One-Way ANOVA) Easy Steps and Video

  1. Ben

    This is clear and simple, and I would like to use it as a teaching resource. However, it does not have subtitles for hearing impaired individuals. Consequently, I would be in violation of American Federal Law if I used it in a lecture with hearing impaired students. I’d encourage adding subtitles for this and future videos!

  2. Andale Post author

    Click the CC button on the bottom right to turn on the captions. If it’s not working for you, I’m not sure why. Have you tried to view them on a different computer?