SLOPE function

Category: Statistical
Introduced: Excel 2003

Summary

Returns the slope of the linear regression line

Syntax

SLOPE(known_y's, known_x's) The SLOPE function syntax has the following arguments:
• Known_y's Required. An array or cell range of numeric dependent data points.
• Known_x's Required. The set of independent data points.

Example

=SLOPE(A3:A9,B3:B9)

Microsoft Support Page

https://support.microsoft.com/en-us/office/slope-function-11fb8f97-3117-4813-98aa-61d7e01276b9

Back to Functions