# Blog

## What are the steps in running the �ANOVA? ## How do you do a one way ANOVA with post hoc test?

• Steps to perform one-way ANOVA with post-hoc test in Excel 2013 Step 1: Input your data into columns or rows in Excel. Step 2: Click the “Data” tab and then click “Data Analysis.” If you don’t see Data Analysis, load the ‘Data Analysis Toolpak’ add-in. Step 3: Click “ANOVA Single Factor” and then click “OK.”

## How do you calculate SSR in a one-way ANOVA?

• Use the following steps to perform a one-way ANOVA by hand to determine if the mean exam score is different between the three groups: Step 1: Calculate the group means and the overall mean. Step 2: Calculate SSR. In our example, we calculate that SSR = 10 (83.4-85.8)2 + 10 (89.3-85.8)2 + 10 (84.7-85.8)2 = 192.2

## What is the F test statistic for this one-way ANOVA?

• The F test statistic for this one-way ANOVA is 2.358. To determine if this is a statistically significant result, we must compare this to the F critical value found in the F distribution table with the following values:  