FISHERINVfunction 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.
- How to use
- Examples of using
FISHERINVformula not working?
- Similar formulas to
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.
ExamplesHere are a few example use cases that explain how to use the
FISHERINVformula 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.
FISHERINVnot working? Here are some common mistakes people make when using the
FISHERINVGoogle 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.
It's important to provide an argument to the FISHERINV function. If an argument is not provided, the function will return an error.
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:
FISHERfunction 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.
CORRELformula 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).
STDEVfunction 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.
TTESTformula 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.