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:-
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:-
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).
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.