Returns the inverse Fisher transformation of a specified value. Learn more
In Google Sheets, the FISHERINV function is used to calculate the inverse Fisher transformation of a given value.
The Fisher transformation is commonly used in statistics to stabilize the variance of a quantity that is proportional to a probability.
It is often used in correlation analysis or when working with data that does not follow a normal distribution.
The syntax for the FISHERINV function is as follows:
FISHERINV(value)
This formula will return the original value that was transformed using the Fisher transformation with a value of 0.7.
Please note that the FISHERINV function is only available in newer versions of Google Sheets and may not be supported in older versions or other spreadsheet software.
The value parameter represents the value for which you want to calculate the inverse Fisher transformation. This value should be between -1 and 1.
The FISHERINV function returns the original value before it was transformed using the Fisher transformation.
Here's an example to illustrate its usage:
=FISHERINV(0.7)