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. In Cell B1 and C1 type "X" and "Y"
2. Enter Coordinates in Excel : In cell B2 and C2 enter your first coordinates (x and y).
3. In cell B3 and C3 enter your second set of coordinates.
4. Calculate the Slope: In C4 type "=slope(C2:C3,B2:B3)"
5. You have the slope!

To calculate without the function

1. Repeat steps 1 - 3 above:
2. In cell B5, calculate the difference in X coordinates by typing:
   • =B2-B3
3. In cell C5, calculate the difference of Y coordinates by typing:
   • =C2-C3
4. In cell C7, calculate the rise over run by typing:
   • =C5/B5

Tips

• Do both and check that the answers are the same
• The help search is great if you just search "slope"
• Instead of typing C2:C3 you can drag over those cells to select

Warnings

• Make sure to select the Y values first in the slope command.

Related Articles

• Reject Outliers in Data
• Calculate Mean and Standard Deviation With Excel 2007
• Calculate Mean, Standard Deviation, and Standard Error
• Calculate a Test Grade
• Make Equations and Get the Answer in Excel

See also

• Create a Sin and Cos Circle in Excel
• Add a Header or Footer in Excel 2007
• Calculate CAGR in Excel
• Use Excel for Your Finances
• Parse Data in Excel
• Create Custom Lists in Excel
• Remove Leading or Trailing Zeros in Excel
• Remove Spaces Between Characters and Numbers in Excel
• Use Vlookup With an Excel Spreadsheet
• Create a User Defined Function in Microsoft Excel

Read more ...

What links here

• Calculate a Test Grade
• Calculate Mean, Standard Deviation, and Standard Error
• Calculate Mean and Standard Deviation With Excel 2007
• Calculate Slope and Intercepts of a Line
• Calculate a Monthly Payment in Excel
• Reject Outliers in Data
• Run a Multiple Regression in Excel