Functions
SLOPE
Slope of linear regression
Try it
When to use it
When should I use SLOPE?
Use SLOPE to find the rate of change (rise over run) in a linear regression between two variables — for example, how much sales revenue increases for each additional unit of advertising spend.
Used in
Syntax
SLOPE(known_y,known_x)Examples
=SLOPE({2,3,9,1,8,7,5},{6,5,11,7,5,4,4}) // => 0.3055555555555555