FISHERINV

Formulas / FISHERINV
Calculate 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.

    • 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.

  • 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.


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?
The FISHERINV function is a statistical function in Sourcetable used to calculate the inverse of the Fisher transformation. The Fisher transformation is used to analyze correlations between ranges or arrays of data.
What does the FISHERINV function take as an argument?
The FISHERINV function takes a nonnumeric y 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?
The FISHER function is used to calculate the Fisher transformation, while the FISHERINV function is used to calculate the inverse of the Fisher transformation.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV