FISHERINV

The FISHERINV function in Google Sheets returns the inverse Fisher transformation of a specified value, converting a Fisher-transformed value back into its original correlation coefficient. It's typically used alongside FISHER in correlation and regression analysis. Dive into our comprehensive guide to master its application.

Parameters

• value: The value for which to calculate the inverse Fisher transformation.

Step-by-Step Tutorial

1. Reversing a Fisher transformation:

   • Example: =FISHERINV(0.5)
   • Result: 0.4621...

2. Pairing with FISHER:

   • Example: =FISHERINV(FISHER(0.6))
   • Result: 0.6 (the original correlation coefficient, recovered)

Use Cases and Scenarios

1. Correlation Analysis: Convert a Fisher z-score back into an interpretable correlation coefficient.
2. Confidence Intervals: Translate confidence bounds computed on Fisher-transformed values back to correlation scale.
3. Statistical Research: Reverse transformations applied during hypothesis testing on correlated data.

Related Functions

• FISHER: Returns the Fisher transformation of a specified value.
• CONFIDENCE.T: Calculates the width of a confidence interval using the t-distribution.

Related Articles

• Understanding Statistical Functions in Google Sheets