SLOPE(known_y's [,known_x's])

Returns the slope of a linear regression line through the given data points.

known_y'sThe array or cell range of numeric dependent data points.
known_x's(Optional) The set of independent data points.

* The slope is the vertical distance divided by the horizontal distance between any two points on the line, which is the rate of change along the regression line.
* The arguments must be either numbers or names, arrays, or references that contain numbers.
* If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
* If "known_y" and "known_x" are empty or have a different number of data points, then #N/A is returned.
* For the Microsoft documentation refer to
* For the Google documentation refer to

1=SLOPE({1, 2, 3, 4}, {5, 6, 7, 8}) = 1
2=SLOPE({2, 3, 9, 1, 8, 7, 5}, {6, 5, 11, 7, 5, 4, 4}) = 0.306

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top