# FISHERINV

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.

## Usage

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

Parameters:
1. 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 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:

• `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 t-test, which can be used to determine if the null hypothesis should be rejected or not.

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