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)
See Also