How to Calculate Slope in Excel

Calculating the slope of a line is extremely simple. It can be done with a function, as well as the using the same methods that are completed when calculating the slope by hand.

Steps

  1. Image titled Calculate Slope in Excel Step 1
    1
    In Cell B1 and C1 type "X" and "Y"
  2. Image titled Calculate Slope in Excel Step 2
    2
    Enter Coordinates in Excel : In cell B2 and C2 enter your first coordinates (x and y).
    Advertisement
  3. Image titled Calculate Slope in Excel Step 3
    3
    In cell B3 and C3 enter your second set of coordinates.
  4. Image titled Calculate Slope in Excel Step 4
    4
    Calculate the Slope: In C4 type "=slope(C2:C3,B2:B3)"
  5. Image titled Calculate Slope in Excel Step 5
    5
    You have the slope!
    6. Advertisement
Method 1
Method 1 of 1:

To calculate without the function

  1. Image titled Calculate Slope in Excel Step 6
    1
    Repeat steps 1 - 3 above:
  2. Image titled Calculate Slope in Excel Step 7
    2
    In cell B5, calculate the difference in X coordinates by typing:
    • =B2-B3
  3. Image titled Calculate Slope in Excel Step 8
    3
    In cell C5, calculate the difference of Y coordinates by typing:
    • =C2-C3
  4. Image titled Calculate Slope in Excel Step 9
    4
    In cell C7, calculate the rise over run by typing:
    • =C5/B5
    5. Advertisement

Warnings

Advertisement

You Might Also Like

Calculate Mean and Standard Deviation With Excel 2007
How to
Calculate Mean and Standard Deviation With Excel 2007
Calculate Mean, Standard Deviation, and Standard Error
How to
Calculate Mean, Standard Deviation, and Standard Error
Calculate a Test Grade
How to
Calculate a Test Grade
Make a Spreadsheet in Excel
How to
Make a Spreadsheet in Excel
Unprotect an Excel Sheet
How to
Unprotect an Excel Sheet
Create a Mortgage Calculator With Microsoft Excel
How to
Create a Mortgage Calculator With Microsoft Excel
Create a Graph in Excel
How to
Create a Graph in Excel
Create a Timeline in ExcelHow to Create a Timeline in Excel: SmartArt, Templates, and More
Change from Lowercase to Uppercase in Excel
How to
Change from Lowercase to Uppercase in Excel
Current Time 0:00
Duration -:-
Loaded: 0%
Stream Type LIVE
Remaining Time -:-
 
1x
How to
Unhide Rows in Excel
Insert Pictures in Excel That Automatically Size to Fit Cells
How to
Insert Pictures in Excel That Automatically Size to Fit Cells
Convert Excel to Word3 Easy Ways to Convert Microsoft Excel Data to Word
Use ExcelNew to Excel? Here's Super Easy Tricks to Get You Started
Merge Cells in ExcelHow to Merge Cells in Microsoft Excel: A Quick Guide
Advertisement

About This Article

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time. This article has been viewed 267,968 times.
How helpful is this?
Co-authors: 4
Updated: April 2, 2020
Views: 267,968
Categories: Microsoft Excel
Advertisement