Home › Functions › Statistical › SLOPE
fx
SLOPE
Statistical  ·  Since: Excel 2003  ·  9 languages

Returns the slope of the linear regression line through data points in known_y's and known_x's. 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.

🌐 Translations

English SLOPE
Deutsch STEIGUNG
Français PENTE
Español PENDIENTE
Italiano PENDENZA
Português INCLINAÇÃO
Nederlands RICHTING
Polski NACHYLENIE
Русский НАКЛОН

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

SLOPE(known_y's,known_x's)

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.

▶ Examples

=SLOPE(A3:A9,B3:B9)

Related functions

Copied to clipboard