Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
SLOPE
SLOPE calculates how much the y variable changes for each one-unit increase in x, derived from the least-squares best-fit line. Use it to quantify the rate of change between two variables, such as how much revenue grows for each additional unit sold.
Excel
=SLOPE(B2:B5,A2:A5)Google Sheets
=SLOPE(B2:B5,A2:A5)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Units | Revenue |
| 10 | 500 |
| 20 | 850 |
| 30 | 1200 |
| 40 | 1600 |
=SLOPE(B2:B5,A2:A5)→36.5
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Place your dependent (y) values in one range and your independent (x) values in another parallel range.
- 2Make sure both ranges contain the same number of numeric data points.
- 3Enter =SLOPE(known_ys, known_xs) to get the slope coefficient of the best-fit line.
Need a version for your data?
Try: “Calculate the rate at which revenue increases per additional unit sold”