FISHERINV
Formulas / FISHERINVCalculate the inverse of the Fisher transformation.
FISHERINV(y)
- Y - required, the value to inverse the Fisher transformation of
Examples
FISHERINV(0.972955)The FISHERINV function returns the inverse of the Fisher transformation. The Fisher transformation is used to convert correlation coefficients into a normal distribution. For example, if y is 0.972955, the function will return 0.75.
FISHERINV(0.6)The FISHERINV function can also be used to determine the probability of a correlation between two variables. For example, if the correlation coefficient is 0.6, you can use the function to calculate the probability that the correlation is real. The probability is calculated by transforming the correlation coefficient into a z-score and then determining the probability of the z-score.
The Fisher transformation is commonly used in statistics for hypothesis testing and to test the correlation between two variables. For example, if you have two sets of data, you can use the correlation coefficient to determine if there is a correlation between the two sets. If the correlation coefficient is greater than 0.9, it can be transformed to a normal distribution using the FISHERINV function.
The FISHERINV function can also be used to test whether a correlation coefficient is significant. For example, if the correlation coefficient is 0.75, you can use the FISHERINV function to transform the coefficient into a z-score. If the z-score is greater than 2 or less than -2, then the correlation is considered to be significant.
Summary
The FISHERINV function is used to calculate the inverse of the Fisher transformation, a tool used to analyze the correlations between ranges or arrays of data.
- The FISHERINV function is used to calculate the inverse of the Fisher transformation, a tool used to determine the correlation between two or more ranges or arrays of data.
- The Fisher transformation is used to convert a correlation coefficient into a form that allows for easy comparison between different correlations.
- The result of the FISHERINV function is the correlation coefficient in its original form.
Frequently Asked Questions
What is the FISHERINV function?
What does the FISHERINV function take as an argument?
What are some uses of the FISHERINV function?
- It can be used to measure the strength of a correlation between two variables.
- It can be used to compare correlations between different sets of data.
- It can be used to test a hypothesis about the relationship between two variables.
What is the difference between the FISHERINV function and the FISHER function?
