Administrators, writer
3,314
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + + − '''FTEST''' ('''arr1''',''' arr2''')+ + + + + + − Where '''arr1''' is the first array or range of data and a'''rr2''' is the second array or range of data.+ + + − </div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − F-test calculates the two-tailed probability that the variances in arr1 and arr2 are not significantly different.+ − + − </div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − · The arguments must either be numbers or names, arrays, or references that contain numbers. − − · When the number of data points in arr1 or arr2 is less than 2, or if the variance of arr1 or arr2 is zero FTEST displays NaN. − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">FTEST</div></div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − − {| id="TABLE3" class="SpreadSheet blue" − |- class="even" − | class=" " | − <div id="2Space_Copy" title="Click and Drag over to AutoFill other cells."></div> − | class=" " | Column1 − | class=" " | Column2 − | class=" " | Column3 − | class=" " | Column4 − |- class="odd" − | class=" " | Row1 − | class="sshl_f " | 5 − | class="sshl_f " | 17 − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | class=" " | Row2 − | class="sshl_f" | 10 − | class="sshl_f" | 28 − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | Row3 − | class="sshl_f" | 4 − | class="sshl_f" | 35 − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | Row4 − | class="sshl_f" | 8 − | class="sshl_f" | 48 − | class="sshl_f" | − | class="sshl_f" | − |- class="odd" − | class=" " | Row5 − | class=" " | 19 − | class="sshl_f " | 40 − | class="sshl_f" | − | class="sshl_f" | − |- class="even" − | class="sshl_f" | Row6 − | class="sshl_f" | 0.21573734399999997 − | class="sshl_f" | − | class="sshl_f" | − | − |- class="odd" − | class="sshl_f" | Row7 − | class="sshl_f " | − | class="SelectTD" | − | class="sshl_f" | − | class="sshl_f" | − |} − − <div align="left">[[Image:calci1.gif]]</div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"><font size="3"><font face="Times New Roman">''' <font size="3"><font face="Times New Roman">AVEDEV (N1, N2...)</font></font> <font size="3"><font face="Times New Roman">Where N1, N 2 ... are positive integers.</font></font> '''</font></font></div> − ---- − <div id="5SpaceContent" class="zcontent" align="left"> − − i.e =FTEST (C1R1:C1R5, C2R1:C2R5) is 0.2157 − − </div> − ----
no edit summary
<div id="6SpaceContent" class="zcontent" align="left">
<div style="font-size:30px">'''FTEST(ar1,ar2)'''</div><br/>
*<math>ar1</math> and <math>ar2 </math> are array of data.
==Description==
*This function gives the result of F-test.
*The F-test is designed to test if two population variances are equal.
*It does this by comparing the ratio of two variances.
*So, if the variances are equal, the ratio of the variances will be 1.Let X1, ..., Xn and Y1, ..., Ym be independent samples each have a normal distribution .
*It's sample means: X(bar)=1/n summation(i=1 to n)Xi and Y(bar)=1/m summation(i=1 to m)Yi .
*The sample variances : Sx^2=1/n-1 summation(i=1 to n)(Xi-X(bar))^2.and SY^2=1/m-1 summation(i=1 to m)(Yi-Y(bar))^2.
*Then the test statistic= Sx^2/Sy^2 has an F-distribution with n − 1 and m − 1 degrees of freedom.
*In FTEST(ar1,ar2) where ar1 is the data of first array,ar2 is the data of second array.
*The array may be any numbers, names, or refernces that contains numbers.
*Suppose the array contains any text, logical values or empty cells like that values are not considered.
When the ar or ar2 is less than 2 or the variance of the array value is zero then this function will return the result as error.
==Examples==
#Find the correlation coefficients for X and Y values are given below :X={1,2,3,4,5}; Y={11,22,34,43,56}
=CORREL(A4:A8,B4:B8)=0.99890610723867
#The following table gives the math scores and times taken to run 100 m for 10 friends:SCORE(X)={52,25,35,90,76,40}; TIME TAKEN(Y)={11.3,12.9,11.9,10.2,11.1,12.5}
=CORREL(A5:A10,B5:B10)= -0.93626409417769
#Find the correlation coefficients for X and Y values are given below :X={-4,11,34,87};Y={9,2,59,24}
=CORREL(A1:A4,B1:B4)=0.353184665607273
==See Also==
*[[Manuals/calci/FDIST | FDIST ]]
*[[Manuals/calci/FINV | FINV ]]
==References==
[http://en.wikipedia.org/wiki/Pearson_product-moment_correlation_coefficient| Correlation]