The `FISHERINV` function in Excel is used to calculate the inverse of the Fisher transformation. The Fisher transformation is commonly used in statistics to transform correlations into a normally distributed scale. This can be useful for constructing confidence intervals around correlation coefficients.
Syntax
FISHERINV(y)
- y: The value for which you want to calculate the inverse Fisher transformation. It is a required argument and should be a numeric value.
Example
Suppose you have a value of 0.2 that represents the result from a Fisher transformation, and you want to convert it back using the inverse.
=FISHERINV(0.2)
- Click on the cell where you want the result to appear.
- Enter the formula:
- Press Enter.
The cell will display the result of the inverse Fisher transformation.
Use Case
The `FISHERINV` function is particularly useful when working with correlation coefficients. If you have applied a Fisher transformation to a correlation coefficient to normalize it for certain analyses, you can later use `FISHERINV` to revert it back to the original correlation scale.
Note
- The `FISHERINV` function is available in Excel 2010 and later versions.
- Be sure that calculations involving statistical transformations like Fisher transformations are appropriate for your data and analysis context.
Unlock Your Potential
Excel
Access
Power BI
