Microsoft Office Tutorials and References
In Depth Information
FIN FINV returns the inverse of the F probability distribution.
The FINV function is when you know the significance level you want to achieve and need to
generate x. An example of an FINV function is =FINV(.025,4,6) which results in 6.23.
Is the probability associated with the F cumulative
distribution—the significance level.
Is the numerator of freedom.
Is the denominator of freedom.
FINV uses an iterative technique for calculating the function. The default maximum number of
iterations is 100. If a result is not reached within those iterations, the #N/A value is returned.
You can change the number of iterations under Tools, Options, Calculation tab.
FISHER returns the Fisher transformation at x.
The FISHER function is used to perform hypothesis testing on the correlation coefficient. An
example of a FISHER function is =FISHER(.95) which results in 1.831780823 .
Is the numeric value for which you want the transformation; must be between
–1 and +1.
The equation for the Fisher transformation is
FISHERINV returns the inverse of the Fisher transformation.
Use this transformation when analyzing correlations between ranges or arrays of data. If
y=FISHER(x) , then FISHERINV(y)=x . An example of a FISHERINV function is =FISHERINV(1.5) ,
which results in 0.905148254 .
Is the value for which you want to perform the inverse of the transformation.