FISHER function - The function returns the Fissher transformation at x in Excel
The following article introduces you to the FISHER function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the Fissher transformation at x. This transformation creates a normal distribution function, using this function to test a hypothesis based on a correlation coefficient.
Syntax: FISHER (x)
Inside:
- x: Numerical value to convert Fissher .
Attention:
- If x is not a number -> the function returns the #VALUE! Error value .
- If x ≤ -1 or x ≥ 1 -> the function returns the #NUM! Error value
- Fissher transform equation is:
[z '= frac {1} {2} ln left ({frac {{1 + x}} {{1 - x}}} right)]
For example:
Calculate the value of x after performing the fissher transformation using the data in the following data table:
- In the cell to calculate enter the formula : = FISHER (C6)
- Press Enter -> the value of x after performing the fissher transformation is:
- Similarly copy to the remaining values are results:
- Where x ≤ -1 or x ≥ 1 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using FISHER function in Excel.
Good luck!
You should read it
- How to use the IFS function in Excel 2016
- CHISQ.TEST function - The function returns the independence test in Excel
- OR function in Excel, how to use the OR function, and examples
- FORECAST function - The function returns a value along a linear trend in Excel
- GAMMA function - The function returns the gamma function value in Excel
- POISSON.DIST function - The function returns the Poisson distribution in Excel
- PHI function - The function returns the value of the density function for a normal distribution in Excel
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excel
May be interested
- FORECAST function - The function returns a value along a linear trend in Excelforecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- How to use the IFS function in Excel 2016the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.
- FTEST function - The function returns the result of an F-Test in Excelthe following article details how to use ftest - the function returns the result of an f-test. in statistical probability, the determination of the correctness and the deviation between two data samples is a regular and extremely important job.
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excelgamma.inv: the function returns the inverse of the gamma distribution, using this function to study their distribution variables that may be symmetrical. support functions from excel 2010 onwards. syntax: gamma.inv (probability, alpha, beta)
- How to use ADDRESS function in Excelthe address function in excel takes the number of rows and column numbers as arguments and returns the reference of the standard cell (cell address). for example, if you go to row 4 and column 3, the function returns c4.
- QUARTILE function - The function returns the quartile of a dataset in Excelthe quartile is an indispensable value in the field of surveying and sales, it helps you evaluate certain criteria in a set. the following article details how to use quartile function, the function returns the quartile of a dataset.
- POISSON function - The function returns the Poisson distribution in Excelin predicting the number of events that occur within a specific time, one cannot help but use the poisson function. the following article details how to use the poisson function, the function returns the poisson distribution.
- OR function in Excel, how to use the OR function, and examplesthe following article details the meaning and usage of the or - logic function in excel. description: the or function is a function that returns the logical value in excel.
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excellognorm.inv: the function returns the inverse of the logarithmic distribution of x. where ln (x) is usually distributed with parameter mean and standard deviation. use functions to analyze logarithmic change data. support function from excel 2 version