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
In Cell B1 and C1 type "X" and "Y"
Enter Coordinates in Excel : In cell B2 and C2 enter your first coordinates (x and y).
In cell B3 and C3 enter your second set of coordinates.
Calculate the Slope: In C4 type "=slope(C2:C3,B2:B3)"
You have the slope!
To calculate without the function
Repeat steps 1 - 3 above:
In cell B5, calculate the difference in X coordinates by typing: =B2-B3
In cell C5, calculate the difference of Y coordinates by typing: =C2-C3
In cell C7, calculate the rise over run by typing: =C5/B5
Comments
0 comment