The FISHERINV function in Google Sheets is a statistical function that provides the inverse of the Fisher transformation. This function is particularly useful in the fields of finance and statistics when working with correlation coefficients, helping users transform values back from Fisher’s z-score format to a correlation coefficient.

Syntax

FISHERINV(value)

value: This is the value that represents a Fisher-transformed statistic. It must be a numeric value.

Example #1

FISHERINV(0.5)

This function converts the Fisher-transformed value of 0.5 back to its correlation coefficient. The result will be approximately 0.4624.

Example #2

FISHERINV(1.0)

In this case, the function will take the Fisher-transformed value of 1.0 and return approximately 0.7602, which is its corresponding correlation coefficient.

Example #3

FISHERINV(-0.5)

This function inputs a Fisher-transformed value of -0.5 and outputs a correlation coefficient of roughly -0.4624, demonstrating the inverse transformation process.

Error handling

• NUM! This error occurs when the input value is outside the range of valid Fisher-transformed values, which should be a real number. Ensure that the value provided is valid.
• VALUE! This error indicates that the input is not a valid number. Check the input to confirm that it is numeric.

Conclusion

In summary, the FISHERINV function is an essential tool for anyone involved in statistical analyses or financial modeling. By converting Fisher-transformed values back to correlation coefficients, it aids users in interpreting relationships between variables more intuitively. Understanding its syntax, usage, and potential error messages ensures effective application in Google Sheets.