How to Use the FISHER Function in Excel

This guide explains how to use FISHER Function in Excel, including its syntax, required arguments, practical examples, and common errors.

Description: The function returns the Fissher transformation at x. This transformation creates a normal distribution function, using this function to test a hypothesis based on a correlation coefficient.

Syntax: FISHER (x)

Inside:

- x: Numerical value to convert Fissher .

Attention:

- If x is not a number -> the function returns the #VALUE! Error value.

- If x ≤ -1 or x ≥ 1 -> the function returns the #NUM! Error value

- Fissher transform equation is:

[z '= frac {1} {2} ln left ({frac {{1 + x}} {{1 - x}}} right)]

For example:

Calculate the value of x after performing the fissher transformation using the data in the following data table:

- In the cell to calculate enter the formula : = FISHER (C6)

- Press Enter -> the value of x after performing the fissher transformation is:

- Similarly copy to the remaining values are results:

- Where x ≤ -1 or x ≥ 1 -> the function returns the #NUM! Error value

Above are instructions and some specific examples when using FISHER function in Excel.

Good luck!