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