Formula Functions > Functions R to S > SLOPE |
This function calculates the slope of a linear regression.
SLOPE(array_dep,array_ind)
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.
Accepts numeric data for both arguments. Returns numeric data.
SLOPE(A1:A4,B1:B4)
This function is available in product version 1.0 or later.
SERIESSUM | Math and Trigonometry Functions