ANOVA provides the first opportunity to determine which factors have a significant effect on a given set of data. After the analysis is completed, an analyst does extra analysis on the methodological factors that significantly impact the inconsistent nature of data sets. If you are looking for some special tricks to graph ANOVA results in Excel, you’ve come to the right place. There are numerous ways to graph ANOVA results in Excel. This article will discuss three suitable examples of graph ANOVA results in Excel. Let’s follow the complete guide to learn all of this.

**Table of Contents**Expand

## What Is ANOVA Analysis?

ANOVA allows you to determine which factors have a significant influence on a given set of data. After the analysis is completed, an analyst does extra analysis on the methodological factors that significantly impact the inconsistent nature of data sets. And he uses the Anova analysis findings in the f-test in order to create extra data relevant to the estimated regression analysis. The ANOVA analysis compares many data sets simultaneously to see whether there is a link between them. ANOVA is a numerical method used to evaluate variance observed within a dataset by dividing it into two sections: 1) Systematic factors and 2) Random factors

The Formula of Anova:

`F= MSE / MST`

where:

**F **= Anova coefficient

**MST **= Mean sum of squares due to treatment

**MSE** = Mean sum of squares due to error

Anova is of two types: single factor and two factors. The method is related to variance analysis.

- In two factors, there are multiple dependent variables and in one factor, there will be one dependent variable.
- Single-factor Anova calculates the effect of one single factor on a single variable. And it checks whether all the sample data sets are of same or not.
- Single-factor Anova identifies the differences that are statistically significant between the average means of numerous variables.

## How to Graph ANOVA Results in Excel: 3 Suitable Examples

We will use three effective and tricky examples to graph ANOVA results in Excel. This section provides extensive details on the three ways. You can use either one for your purpose, they have a wide range of flexibility when it comes to customization. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge. We use the **Microsoft Office 365** version here, but you can utilize any other version according to your preference. Before following the examples below, you must first enable the data analysis toolpak in Excel.

### 1. Plotting Graph for ANOVA: Single Factor

Here, we will demonstrate how to graph Anova analysis in Excel. Let us first introduce you to our Excel dataset so that you are able to understand what we are trying to accomplish with this article. We have a dataset showing group of factors. Let’s walk through the steps to do a single factor ANOVA analysis and then graph results in Excel.

**📌 Steps:**

- First, go to the
**Data**tab in the top ribbon. - Then, select the
**Data Analysis**tool.

- When the
**Data Analysis**window appears, select the**Anova: Single Factor**option. - Then, click on
**Ok**.

** **

- Now, the
**Anova: Single Factor**window will open. - Then, select the cells in the
**Input Range**box. - Check the box named
**“Labels in First Row”**. - In the
**Output Range**box, provide the data range that you want your calculated data to store by dragging through the column or row. Or you can show the output in the new worksheet by selecting**New Worksheet Ply**and you can also see the output in the new workbook by selecting New Workbook. - Next, you have to check the
**Labels in the first row**if the input data range with the label. - Next, click on
**OK**.

** **

- As a consequence, the Anova outcomes will be as shown below.
- In the Summary table, you will find each group’s average and variances. Here you can see the average level is
**53.8**for Group a but the variance is**528.6**which is low than other group c. That means, that in the group members are less valuable. - Here, Anova results are not that significant as you are calculating only the variances.
- Here, P-values interpret the relation between the columns and the values are greater than 0.05, so this is not statistically significant. And there shouldn’t relation between the columns also.

- Now, we are going to insert a
**Clustered Column**for our results. - First of all, select the range of the cells as shown below.
- Now, in the Insert tab, click on the drop-down arrow of the
**Insert Column or Bar Chart**from the**Charts**group. - Then, choose the
**Clustered Column**chart.

- As a consequence, you will get the following clustered column chart. Here we can see the difference between the sum, average, and variance values between the different groups.

- To modify the chart style, select
**Chart Design**and then, select your desired**Style 8**option from the**Chart Styles**group. - Or you can right-click on the chart, select the
**Chart Styles**icon, and select your desired style as shown below.

- Finally, you will be able to graph the Anova results as shown below.

### 2. Plotting Graph for ANOVA: Two Factor with Replication

Suppose you have some data on different exam scores of a school. There are two shifts in that school. One is for the morning shift other is for the day shift. You want to do a Data Analysis of the ready data to find a relation between two shifts’ students’ marks. Let’s walk through the steps to do a two-factor with replication ANOVA analysis and then graph results in Excel.

**📌 Steps:**

- First, go to the
**Data**tab in the top ribbon. - Then, select the
**Data Analysis**tool.

- When the
**Data Analysis**window appears, select the**Anova: Two-Factor With Replication**option. - Next, click on
**OK**.

** **

- Now, a new window will appear.
- Then, select the data range in the
**Input Range**box. - Next, input
**4**in the**Rows per sample**box as you have**4**rows per shift. - In the
**Output Range**box, provide the data range that you want your calculated data to store by dragging through the column or row. Or you can show the output in the new worksheet by selecting**New Worksheet Ply**and you can also see the output in the new workbook by selecting New Workbook. - Finally, press
**OK**.

- As a result, you will see a new worksheet created.
- And, two-way Anova result is shown in this worksheet.
- Here, the first tables, there are showing the summary of shifts. In brief:
- The average score in the Morning shift in Math score is
**65.5**but in the Day shift is**83.75**. - But when in the Chemistry exam, the average score in the Morning shift is 87 but in the Day shift is
**77.5**. - Variance is very high at
**91**in the morning shift in the Math exam. - You will get a complete overview of the data in the summary.
- Likewise, you can summarise the interactions and individual effects in the Anova part. In brief:
- The P-value of Columns is
**0.037**which is statistically significant so you can say that there is an effect of shifts on the performance of the students in the exam. But the value is close to the alpha value of**0.05**so the effect is less significant. - But the P-value of interactions is
**0.000967**which is much less than the alpha value so it is very much significant statistically and you can say that the effect of the shift on both exams is very high.

- Now, we are going to insert a
**Clustered Column**for our results. - First of all, select the range of the cells as shown below.
- Now, in the Insert tab, click on the drop-down arrow of the
**Insert Column or Bar Chart**from the**Charts**group. - Then, choose the
**Clustered Column**chart.

- As a consequence, you will get the following clustered column chart. To Modify the chart, click on the chart and select
**Select Data**from the**Data**tab as shown below.

- Therefore, the
**Select Data Source**window will appear. - Then, select
**Serires1**and click on**Edit**.

- Consequently, the
**Edit Series**window will appear. - Then type the series name as shown below.
- Next click on
**OK**.

- Following a similar process, you have to rename
**Series2**. - Next, to modify the chart style, select
**Chart Design**and then, select your desired**Style 8**option from the**Chart Styles**group. - Or you can right-click on the chart, select the
**Chart Styles**icon, and select your desired style as shown below.

- Finally, you will be able to get the following chart of the average score of two shits. Here, Axes 1 indicates the average math score of two shifts, and axes 1 indicates the average chemistry score of two shifts.

- Now, we are going to insert a clustered bar for the variance of scores.
- First of all, select the range of the cells as shown below.
- Now, in the Insert tab, click on the drop-down arrow of the
**Insert Column or Bar Chart**from the**Charts**group. - Then, choose the
**Clustered Bar**chart.

- Consequently, you will get the following chart.

- After modifying following the above process, you will get the following chart of the variance of two shifts. Here, Axes 1 indicates the variance of the math score of two shifts, and axes 1 indicates the variance of the chemistry score of two shifts.

This is how you will be able to graph the Anova results.

### 3. Plotting Graph for ANOVA: Two Factor Without Replication

Now, we are going to do variance analysis by following the method of two factors without replication ANOVA Analysis and graph results in Excel. We Suppose you have some data on different exam scores of a school. There are two shifts in that school. One is for the morning shift other is for the day shift. You want to do a Data Analysis of the ready data to find a relation between two shifts’ students’ marks. Let’s walk through the steps to do a two-factor without replication Anova analysis and then graph results in Excel.

**📌 Steps:**

- First, go to the
**Data**tab in the top ribbon. - Then, select the
**Data Analysis**tool.

- When the
**Data Analysis**window appears, select the**Anova: Two-Factor Without Replication**option. - Next, click on
**OK**.

** **

- Now, a new window will appear.
- Then, select the data range in the
**Input Range**box. - In the
**Output Range**box, provide the data range that you want your calculated data to store by dragging through the column or row. Or you can show the output in the new worksheet by selecting**New Worksheet Ply**and you can also see the output in the new workbook by selecting New Workbook. - Next, you have to check the
**Labels**if the input data range with the label. - Finally, click on
**OK**.

- As a result, you will see a new worksheet created.
- As a consequence, you will get the two-way Anova result as shown below.
- The average score in the Morning shift in Math score is
**65.5**but in the Day shift is**83.75**. - But when in the Chemistry exam, the average score in the Morning shift is 87 but in the Day shift is
**77.5**. - The P-value of Columns is
**0.24**which is statistically significant so you can say that there is an effect of shifts on the performance of the students in the exam. But the value is close to the alpha value of**0.05**so the effect is less significant.

- Now, we are going to insert a
**Clustered Column**for our results. - First of all, select the range of the cells as shown below.
- Now, in the Insert tab, click on the drop-down arrow of the
**Insert Column or Bar Chart**from the**Charts**group. - Then, choose the
**Clustered Column**chart.

- As a consequence, you will get the following clustered column chart.
- Next, to modify the chart style, select
**Chart Design**and then, select your desired**Style 8**option from the**Chart Styles**group. - Or you can right-click on the chart, select the
**Chart Styles**icon, and select your desired style as shown below.

- After modifying following the above process, you will get the following chart of the average & variance of two shifts. Here, Axes 1 indicates the average of the math score and chemistry score, and axes 1 indicates the variance of the math and chemistry score.
- This is how you will be able to graph the Anova results.

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article. It contains all the datasets and methods in different spreadsheets for a clear understanding.

## Conclusion

That’s the end of today’s session. I strongly believe that from now, you may be able to graph Anova results in Excel. If you have any queries or recommendations, please share them in the comments section below.

Keep learning new methods and keep growing!

## Related Articles

- Nested ANOVA in Excel
- How to Interpret ANOVA Results in Excel
- How to Do Two Way ANOVA in Excel
- How to Make an ANOVA Table in Excel
- How to Calculate P Value in Excel ANOVA
- How to Perform Regression in Excel and Interpretation of ANOVA

**<< Go Back to Anova in Excel | Excel for Statistics | Learn Excel**