Spread Formula Reference
FISHER

This function returns the Fisher transformation for a specified value.

Syntax

FISHER(value)

Arguments

Provide a numeric value that is less than 1 and greater than –1 for which you want the transformation.

Remarks

This transformation produces an approximately normal distribution. Use this function to perform hypothesis testing on the correlation coefficient.

The Fisher transformation is calculated as follows:

FISHER Equation

where x is the value argument.

Data Types

Accepts numeric data. Returns numeric data.

Examples

FISHER(A43)

FISHER(R4C12)

FISHER(-0.65) gives the result -0.7752987062

Version Available

This function is available in product version 1.0 or later.

See Also

FISHERINV | Statistical Functions

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options