Check Sheet Logo
Check Sheet


The FISHERINV function returns the inverse of the Fisher transformation on a given value. This function is often used to transform data that follows a non-normal distribution to a more normal distribution. The transformed data can then be used for statistical analysis.


Use the FISHERINV formula with the syntax shown below, it has 1 required parameter:

  1. value (required):
    The value to be transformed. Must be between -1 and 1, inclusive.


Here are a few example use cases that explain how to use the FISHERINV formula in Google Sheets.

Transforming data for statistical analysis

Suppose you have a dataset that does not follow a normal distribution, making it difficult to perform statistical analysis. You can use FISHERINV to transform the data to a more normal distribution, allowing you to perform the desired analysis with greater accuracy.

Calculating confidence intervals

The Fisher transformation is often used in calculating confidence intervals for correlation coefficients. By transforming the correlation coefficient with FISHERINV, you can obtain a more accurate confidence interval.

Comparing groups with unequal variances

When comparing two groups with unequal variances, the Welch's t-test is often used. The Fisher transformation is used to transform the test statistic for this test to a normal distribution, making it easier to calculate the p-value. FISHERINV is used to transform the test statistic back to its original scale.

Common Mistakes

FISHERINV not working? Here are some common mistakes people make when using the FISHERINV Google Sheets Formula:

Incorrect argument type

One common mistake is to provide an argument that is not a valid number or reference to a cell containing a number. Make sure that the argument is a number or reference to a cell containing a number.

Value outside of range

Another common mistake is to provide a value outside of the range of -1 to 1. Make sure that the value provided is within this range.

Incorrect function name

Sometimes users may misspell the function name or use a similar function with a different name. Double-check that the function name is spelled correctly and is the correct function for the desired calculation.

Missing argument

It's important to provide an argument to the FISHERINV function. If an argument is not provided, the function will return an error.

Incorrect syntax

Make sure that the syntax used for the FISHERINV function is correct. The function should take one argument, which is a number or reference to a cell containing a number.

The following functions are similar to FISHERINV or are often used with it in a formula:


    The FISHER function returns the Fisher transformation of a given value. This transformation is commonly used in statistics to normalize a distribution and improve the accuracy of hypothesis tests and confidence intervals. The resulting value will always be between -1 and 1, with values closer to 1 indicating a stronger correlation between two variables.


    The CORREL formula returns the correlation coefficient between two sets of data. This coefficient represents the strength of the linear relationship between the two sets of data, with values ranging from -1 (perfect negative correlation) to 1 (perfect positive correlation).


    The STDEV function calculates the standard deviation of a set of numbers. It measures the amount of variation or dispersion of a set of values from the average (mean) value. It is commonly used in statistics to determine the spread of a data set. The values can be supplied as individual cells, ranges, or constants.


    The TTEST formula is a statistical formula used to determine the probability of two sample means being equal. It is commonly used in hypothesis testing to determine if there is a significant difference between two sets of data. The formula returns the probability value associated with a t-test, which can be used to determine if the null hypothesis should be rejected or not.

Learn More

You can learn more about the FISHERINV Google Sheets function on Google Support.