FISHER

Name

Fisher

Description

Returns the Fisher transformation for a specified value.

Syntax

FISHER(value)

Remarks

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

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:where x is the value argument.

Data Type

Accepts numeric data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

FISHER(A43)
FISHER(R4C12)
FISHER(-0.65)=-0.7752987062