Excel SLOPE Function

Statistical Function ยท Intermediate Level

What is SLOPE?

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

Syntax

=SLOPE(known_y's, known_x's)

Example

Formula: =SLOPE(A1:A10, B1:B10)

Result: 2.5

How It Works

Calculates the rate of change (m in y=mx+b) that best fits the data using least squares.

Learn More Excel Functions