Changes

<div style="font-size:30px">'''FTEST(ar1,ar2)'''</div><br/>

<div style="font-size:30px">'''FTEST(array1,array2)'''</div><br/>

*<math>ar1</math> and <math>ar2 </math> are array of data.

*<math>array1</math> and <math>array2 </math> are array of data.

 

==Description==

==Description==

*This function gives the result of F-test.  

*This function gives the result of F-test.  

:<math>SY^2=\frac{1}{m-1} \sum_{i=1}^m (Yi-\bar Y)^2</math>

:<math>SY^2=\frac{1}{m-1} \sum_{i=1}^m (Yi-\bar Y)^2</math>

*Then the Test Statistic = <math>\frac {Sx^2}{Sy^2}</math> has an F-distribution with <math>n−1</math> and <math>m−1</math> degrees of freedom.

*Then the Test Statistic = <math>\frac {Sx^2}{Sy^2}</math> has an F-distribution with <math>n−1</math> and <math>m−1</math> degrees of freedom.

*In FTEST(ar1,ar2) where <math>ar1</math> is the data of  first array, <math>ar2</math> is the data of second array.  

*In FTEST(array1,array2) where <math>array1</math> is the data of  first array, <math>array2</math> is the data of second array.  

*The array may be any numbers, names, or references that contains numbers.  

*The array may be any numbers, names, or references that contains numbers.  

*values are not considered if the array contains any text, logical values or empty cells.  

*values are not considered if the array contains any text, logical values or empty cells.  

When the <math>ar1</math> or <math>ar2</math> is less than 2 or the variance of the array value is zero, then this function will return the result as error.

When the <math>array1</math> or <math>array2</math> is less than 2 or the variance of the array value is zero, then this function will return the result as error.

 

==Examples==

==Examples==