Table of Contents
The FISHERINV function is a mathematical function in Google Sheets that allows users to calculate the inverse Fischer transformation. This transformation is commonly used to normalize data that is not normally distributed. To use the FISHERINV function, simply enter the function in a cell, followed by the numerical value or cell reference of the data you want to transform. The result will be the original data transformed into a normally distributed form. This function can be useful in various statistical analyses and can be easily accessed and utilized in Google Sheets.
FISHERINV
Returns the inverse Fisher transformation of a specified value.
Sample Usage
FISHERINV(0.962)
FISHERINV(A2)
Syntax
FISHERINV(value)
value– The value for which to calculate the inverse Fisher transformation.
See Also
PEARSON: Calculates r, the Pearson product-moment correlation coefficient of a dataset.
FISHER: Returns the Fisher transformation of a specified value.
CORREL: Calculates r, the Pearson product-moment correlation coefficient of a dataset.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdEl4ZXZZLUFuYjZncFFFUDZoSGJjNEE&output=html” width=”500″]
Cite this article
stats writer (2024). How do I use the FISHERINV function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-fisherinv-function-in-google-sheets/
stats writer. "How do I use the FISHERINV function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-fisherinv-function-in-google-sheets/.
stats writer. "How do I use the FISHERINV function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-fisherinv-function-in-google-sheets/.
stats writer (2024) 'How do I use the FISHERINV function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-fisherinv-function-in-google-sheets/.
[1] stats writer, "How do I use the FISHERINV function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the FISHERINV function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.