Funzione di Google Sheets

FISHER

Returns the Fisher transformation for a specified value.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

FISHER(x)

The Fisher transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.

Argomenti

xobbligatorioThe numeric value that you want to transform, where -1 < x < 1.

Esempi

=FISHER(0.5)

Risultato: 0.549306

Calculates the Fisher transformation for the correlation coefficient 0.5.

Domande frequenti

What is the range of x for the FISHER function?

The value of x must be greater than -1 and less than 1.

Funzioni correlate

FISHERINV CORREL