Table of Contents
The FISHER function is a mathematical function available in Google Sheets that allows users to calculate the Fisher transformation of a given value. This transformation is useful in statistics and finance as it converts a non-normally distributed data set into a normally distributed one. To use the FISHER function, simply enter the value you want to transform as the function’s argument. The resulting output will be the transformed value, which can then be used for further analysis or calculations. This function can be particularly helpful in analyzing data that follows a non-normal distribution, allowing for more accurate statistical analysis.
FISHER
Returns the Fisher transformation of a specified value.
Sample Usage
FISHER(0.962)
FISHER(A2)
Syntax
FISHER(value)
value– The value for which to calculate the Fisher transformation.
See Also
PEARSON: Calculates r, the Pearson product-moment correlation coefficient of a dataset.
FISHERINV: Returns the inverse 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=0As3tAuweYU9QdExORS1rTkZuUzBfNzZTeTl5eTMtaUE&output=html” width=”500″]
Cite this article
stats writer (2024). How can I use the FISHER function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-fisher-function-in-google-sheets/
stats writer. "How can I use the FISHER function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-fisher-function-in-google-sheets/.
stats writer. "How can I use the FISHER function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-fisher-function-in-google-sheets/.
stats writer (2024) 'How can I use the FISHER function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-fisher-function-in-google-sheets/.
[1] stats writer, "How can I use the FISHER function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the FISHER function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.