Summary

SLOPE returns the slope of the linear regression line through two sets of data points. In plain language, it tells you how much the Y values change when the X values increase by 1 unit.

This is why SLOPE is often paired with business questions that sound like, "How much more sales do we get for each extra dollar spent?" or "How much do errors drop for each extra hour of training?" It gives you the rate, not just the fact that a relationship exists.

Syntax

=SLOPE(known_y's, known_x's)

The order matters here. Put the dependent values first in known_y's, then put the independent values in known_x's. If you reverse them, the result answers a different question.

Arguments

• known_y's - [required] The Y values, or the results you want to explain.
• known_x's - [required] The X values, or the inputs you think are driving the change.

SLOPE vs Other Functions

SLOPE and CORREL are easy to mix up. CORREL tells you how strongly two lists are related, while SLOPE tells you the size of the change along the fitted line.

Using the SLOPE Function

This function is useful when a per-unit rate is more important than the raw totals. If the slope is 2.5, that means the fitted line increases by 2.5 units in Y for every 1 unit increase in X. If the slope is negative, Y tends to fall as X rises.

Microsoft notes that text, logical values, and blank cells inside referenced ranges are ignored, while zero values are included. If the known Y and known X ranges are empty or have different numbers of data points, Excel returns #N/A. When the calculation cannot determine a slope, Excel can also return #DIV/0!.

• Use it for ad spend vs sales, hours worked vs output, or temperature vs cost.
• Keep the argument order straight so the rate answers the question you actually care about.
• Read the result as a per-unit change, not as a percentage unless your data itself is in percentage units.

Example 1 - Measure growth per unit

This formula shows how much sales change for each extra unit of spend.

=SLOPE(D1:D3,B1:B3) // Returns the sales change per 1 unit of spend.

Example 2 - Measure a negative change

A negative result means the Y values fall as the X values rise.

=SLOPE(D1:D3,B1:B3) // Returns a negative slope when more training lines up with fewer errors.

Example 3 - Estimate cost change from temperature

This is a practical way to summarize how quickly bills rise as the weather gets hotter.

=SLOPE(D1:D3,B1:B3) // Returns the bill increase per degree.

Example 4 - Review a scaling rate

This example turns a simple trend into a rate you can explain to someone else without showing the full dataset.

=SLOPE(D1:D3,B1:B3) // Returns the user increase per spend unit.

Conclusion Recap

• Main job: SLOPE returns the rate of change of a linear regression line.
• How to read it: It shows how much Y changes when X increases by 1.
• Order matters: Put Y values first and X values second.
• Sign matters: Positive means the line rises, while negative means it falls.
• Best use: Use it when you need a clear per-unit rate from paired numeric data.