SLOPE Function Explained
The SLOPE
function in Microsoft Excel calculates the slope of the linear regression line based on the given data points. It takes two arguments: the known_y's
and the known_x's
. It returns the slope of the regression line, which is the rate of change of the dependent variable with respect to the independent variable.
SLOPE Function Syntax
SLOPE(known_y's, known_x's)
- known_y’s: An array or range of dependent y-values that are already known.
- known_x’s: An array or range of independent x-values that are already known.