ANOVA Single Factor in Microsoft Excel

ANOVA- single factor in Microsoft excel is used for analyzing inconsistencies in analytic tools. This tool means more than two independent groups are used to compare it to test three different forms based on what you want to do:-single factor, two-factor with replication, and two factors without replication.

The ANOVA function is a part of Add INS in Microsoft Excel.

To access this tool, click on Data Tab, click on Data Analysis in the Analysis group. If the Data Analysis command is not available then you need to load the Analysis Toolpak.

To load and activate the Analysis Toolpak follow below mentioned steps:-

  • Click the File Tab, Click options and click on Add INS Category.


  • In the Manage box, select the Analysis Toolpak and then click on the Go button.


  • In the Add Ins dialog box, select the Analysis Toolpak check box and then click Ok.
  • If Analysis Toolpak is not listed in the Add Ins available box, clickBrowse to locate it.


Let’s come back to the topic, to generate the ANOVA Single Factor, let’s take an example. We have score data for 3 batches, below you can find the data.


To use the single factor ANOVA, follow below mentioned steps:-

  • Go to Data Tab.
  • Click on Data Analysis in the Analyses group.


  • Data Analysis dialog box will appear.


  • From the Analysis tool drop down menu, select Anova: Single Factor and click on ok.
  • You will get another Anova: Single Factor dialog box will appear.
  • Click on Input range. Select the range A2:C15.
  • Tick on Labels in the first row to get the student’s name as a header in the result.
  • Tick on Output Range and select the cell where you want to show the summary.
  • Click on ok.


In this output, the test statistic F is reported in the analysis of variance table,

F (2,31) =1. 27.. The P- Value for this statistic is P<0.001 (reported in the table as 0.29). This means that there is evidence that there are differences in the means across the group.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube