FISHERINV Function - Returns the inverse value of the Fissher transformation in Excel

This article introduces you to the FISHERINV function - one of the statistical functions highly favored in Excel.

Description: Returns the inverse value of the Fissher transformation. Use this function to analyze the correlation between two data arrays, where y = FISHER(x) -> FISHERINV(y) = x.

Syntax: FISHER(y)

In this context:

- y: The numerical value for performing the inverse transformation of FISHERINV.

Note:

- If y is not a number -> the function returns the error value #VALUE!.

- The transformation equation for FISHERINV is:

x=e2y−1e2y+1$x=\frac{e^{2y}-1}{e^{2y}+1}$

Example:

Calculate the inverse value of y after performing the fissherinv transformation according to the data in the dataset below:

- In the cell where you want to calculate, enter the formula: =FISHERINV(C6)

- Press Enter -> the inverse value of y after performing the fissherinv transformation is:

- Similarly copy for the remaining values to get the result:

- In case y is not a numeric value -> the function returns an error value #VALUE!

Here is the guide and some specific examples when using the FISHERINV function in Excel.

Wishing you all success!