Jump to navigation Jump to search
- is the set of dependent values.
- is the set of independent values.
- SLOPE(), returns the slope of the linear regression line.
- This function gives the slope of the linear regression line through a set of given points.
- The slope of a regression line (b) represents the rate of change in as ,math> x </math> changes.
- To find a slope we can use the least squares method.
- Slope is found by calculating b as the co-variance of and , divided by the sum of squares (variance) of .
- In , is the array of the numeric dependent values and is the array of the independent values.
- The arguments can be be either numbers or names, array, constants or references that contain numbers.
- Suppose the array contains text, logical values or empty cells, like that values are not considered.
- The equation for the slope of the regression line is
where and are the sample mean x and y.
- This function will return the result as error when
1. Any one of the argument is non-numeric. 2. and are empty or that have a different number of data points.
=SLOPE(A1:E1,A2:E2) = -0.305309734513
=SLOPE(A1:F1,A2:F2) = 0.58510638297
=SLOPE(C1:C3) = 0.730769230769