Microsoft Office Tutorials and References

In Depth Information

**FINV**

FIN
FINV
returns the inverse of the F probability distribution.

=FINV(probability,degrees_freedom1,degrees_freedom2)

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.

PROBABILITY

Is the numerator of freedom.

DEGREES FREEDOM1

Is the denominator of freedom.

DEGREES FREEDOM2

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

FISHER
returns the Fisher transformation at
x.

=FISHER(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.

X

The equation for the Fisher transformation is

FISHERINV

FISHERINV
returns the inverse of the Fisher transformation.

=FISHERINV(y)

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.

Y