Spread Formula Reference
SLOPE
Formula Functions > Functions R to S > SLOPE

This function calculates the slope of a linear regression.

Syntax

SLOPE(array_dep,array_ind)

Arguments

This function has these arguments:

Argument Description
array_dep Array of dependent values (y’s)
array_ind Array of independent values (x’s)

The arrays must be the same size.

Data Types

Accepts numeric data for both arguments. Returns numeric data.

Examples

SLOPE(A1:A4,B1:B4)

Version Available

This function is available in product version 1.0 or later.

See Also

SERIESSUM | Math and Trigonometry Functions