Funzione di Google Sheets

SLOPE

Returns the slope of the linear regression line through the given data points.

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

SLOPE(known_ys, known_xs)

The SLOPE function calculates the slope of a line based on the linear regression of two sets of data. The slope is the vertical distance divided by the horizontal distance between any two points on the line.

Argomenti

known_ysobbligatorioAn array or range of dependent data points.
known_xsobbligatorioAn array or range of independent data points.

Esempi

=SLOPE({2,3,9,1,8}, {6,5,11,7,5})

Risultato: 0.305555556

Calculates the slope for the provided arrays of y and x values.

Domande frequenti

What happens if the data points are empty or contain text?

The SLOPE function ignores cells that contain text, logical values, or empty cells.

Funzioni correlate

INTERCEPT LINEST RSQ FORECAST