Home
Tech info
Technology
Science
Life
Application
Electric
Program
Mobile
Windows 10
Windows 11FISHERINV function - Function that returns the inverse of the Fissher transformation in Excel
The following article introduces you to the FISHERINV function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the inverse value of the Fissher transformation . Use this function to analyze the correlation between two data arrays, if y = FISHER (x) -> FISHERINV (y) = x .
Syntax: FISHER (y)
Inside:
- y: The numerical value to perform the inverse of the Fissherinv transformation .
Attention:
- If y is not a number -> the function returns the #VALUE! Error value .
- Fissherinv transform equation is:
[x = frac {{{e ^ {2y}} - 1}} {{{e ^ {2y}} + 1}}]
For example:
Calculate the inverse value of y after performing the fissherinv transformation using the data in the following data table:
- In the cell to calculate enter the formula : = FISHERINV (C6)
- Press Enter -> the inverse value of y after performing the fissherinv transformation is:
- Similarly copy to the remaining values are results:
- Where y is not a numeric form -> the function returns the #VALUE! Error value
Above are instructions and some specific examples when using FISHERINV function in Excel.
Good luck!
Jessica TannerYou should read it
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel
- T.INV function - The function returns the inverse value of the Student t distribution in Excel
- F.INV function - The function returns the inverse of the probability distribution F in Excel
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excel
- MINVERSE function - The function returns the inverse matrix of a given matrix in Excel
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
- NORM.INV function - The function returns the inverse of the standard cumulative distribution in Excel
- T.INV.2T - The function returns the two-sided inverse of the Student's t-distribution in Excel
May be interested
- CHISQ.INV.RT function - The function returns the inverse of the right end probability of the distribution when squared in Excel
chisq.inv.rt function: the function returns the inverse of the right end probability of the distribution when squared. support function from excel 2010 version. syntax: chisq.inv.rt (probability, deg_freedom) - CHISQ.INV function - The function returns the inverse of the probability of the left end of the distribution when squared in Excelchisq.inv function: the function returns the inverse of the probability of the left end of the distribution when squared. support functions from the excel 2010 version. syntax: chisq.inv (probability, deg_freedom)
- NORM.S.INV function - The function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1 in Excelnorm.s.inv function: the function returns the inverse of the normalized distribution with an average value of 0 and a standard deviation of 1. support from excel 2010 onwards. syntax: norm.s.inv (probability)
- NORMINV function - The function returns the inverse of the cumulative distribution in Excelthe following article details how to use the norminv function - the function returns the inverse of the cumulative distribution in excel.
- TINV function - The function returns the inverse of the Student's t-distribution in Exceltinv function: the tinv function supports the calculation of the inverse value of the student's t-distribution associated with the student's 2-t distribution in excel.
- How to use the NORMDIST function in Excel - Function that returns the distribution in Excelthe normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
- CHISQ.TEST function - The function returns the independence test in Excelchisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
- How to use the IF function in Excelthe if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
Office information
- FORECAST function - The function returns a value along a linear trend in Excel
- FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excel
- GAMMA function - The function returns the gamma function value in Excel
- GAMMA.DIST function - The function returns the gamma distribution in Excel
- SECOND function - The function returns the second part of a time value in Excel
- TIME function - Function returns decimal numbers for a specific time value in Excel
FORECAST function - The function returns a value along a linear trend in Excel
FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excel
GAMMA.DIST function - The function returns the gamma distribution in Excel
SECOND function - The function returns the second part of a time value in Excel
TIME function - Function returns decimal numbers for a specific time value in Excel