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 : 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*.

*Facebook page*and I'll do my best to help!

Thank you so much!

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!

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?