FISHERINV
TheFISHERINV
function returns the inverse of the Fisher transformation on a given value. This function is often used to transform data that follows a nonnormal distribution to a more normal distribution. The transformed data can then be used for statistical analysis.
 How to use
FISHERINV
formula?  Examples of using
FISHERINV
formula FISHERINV
formula not working? Similar formulas to
FISHERINV
Usage
Use the FISHERINV
formula with the syntax shown below, it has 1 required parameter:
 value (required):
The value to be transformed. Must be between 1 and 1, inclusive.
Examples
Here are a few example use cases that explain how to use theFISHERINV
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 ttest 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 pvalue. 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. Doublecheck 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.
Related Formulas
The following functions are similar to FISHERINV
or are often used with it in a formula:

FISHER
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. 
CORREL
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). 
STDEV
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. 
TTEST
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 ttest, 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.