F-Test in Microsoft Excel

Array1 and array2 and F-test are not expressively different in the two-tailed possibility which is to differentiate two sample variances to determine whether to use this function. Whether these schools have different levels of test score diversity.

The Syntax of F-Test =FTEST(arrray1,array2)

Array1 is the first array or range of data.

Array2 is the second array or range of data.

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, click Browse to locate it.


Let’s come back to the topic, to analyze the data through F-Test Two-Sample for Variances.

We have remarks score data of 2 groups in the range A2:B12. Column A contains the data of Group 1 and column B contains the data of 2nd Group.

To use the F-Test Two-Sample for Variances, 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, F-Test Two-Sample for Variances and click on ok.
  • You will get F-Test Two-Sample for Variances dialog box will appear.
  • Click on Input range. Select the 1st variable range A1:A12, select the 2nd variable range B1:B12.
  • Tick on Labels in the first row to get the header in the result.
  • Tick on Output Range and select the cell where you want to show the summary.
  • Click on ok.



Important: be sure that the variance of Variable 1 is higher than the variance of Variable 2. This is the case, 2.3<9.2. If not, swap your data. As a result, Excel calculates the correct F value, which is the ratio of Variance 1 to Variance 2 (F = 2.3/9.2= 0.25).

Leave a Reply

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

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 Youtube