FISHER function - The function returns the Fissher transformation at x in Excel

The following article introduces you to the FISHER function - one of the functions in the statistical function group is very popular in Excel.

FISHER function - The function returns the Fissher transformation at x in Excel Picture 1

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:

FISHER function - The function returns the Fissher transformation at x in Excel Picture 2

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

FISHER function - The function returns the Fissher transformation at x in Excel Picture 3

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

FISHER function - The function returns the Fissher transformation at x in Excel Picture 4

- Similarly copy to the remaining values ​​are results:

FISHER function - The function returns the Fissher transformation at x in Excel Picture 5

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

FISHER function - The function returns the Fissher transformation at x in Excel Picture 6

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

Good luck!