Table of Contents
The FISHERINV function in Excel is a mathematical function that allows users to calculate the inverse of the Fisher transformation of a given value. This function is useful in statistical analysis and can help to normalize skewed data. To use the FISHERINV function, users must input the transformed value as the argument and the function will return the original value. This function is helpful for analyzing data sets that follow a non-normal distribution. By using the FISHERINV function, users can easily reverse the Fisher transformation and obtain the original data value. This can aid in making more accurate and meaningful interpretations of statistical results.
This article describes the formula syntax and usage of the FISHERINV function in Microsoft Excel.
Description
Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.
Syntax
FISHERINV(y)
The FISHERINV function syntax has the following arguments:
Y Required. The value for which you want to perform the inverse of the transformation.
Remarks
If y is nonnumeric, FISHERINV returns the #VALUE! error value.
The equation for the inverse of the Fisher transformation is:
Cite this article
stats writer (2024). “How can I use the FISHERINV function in excel?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-fisherinv-function-in-excel/
stats writer. "“How can I use the FISHERINV function in excel?”." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-fisherinv-function-in-excel/.
stats writer. "“How can I use the FISHERINV function in excel?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-fisherinv-function-in-excel/.
stats writer (2024) '“How can I use the FISHERINV function in excel?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-fisherinv-function-in-excel/.
[1] stats writer, "“How can I use the FISHERINV function in excel?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. “How can I use the FISHERINV function in excel?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.