In this Article we will learn to calculate the slope in Excel. Les us try to calculate the slope using simple formula's by using the coordinates of 2 points:
Let us write the coordinates of 2 points:
Calculate difference beteween x coordinates: C5-C4
The result is 2 in this example.
Now let us calculate difference between y coordinates: D5-D4
The result is 2 again.
Slope will be difference of Y coordinates divided by difference of X coordinates:
The Slope here is 1.
This was very simple approach, now we will do the same by using the slope function inbuilt in Excel:
The SLOPE function syntax has the following arguments:
- Known y's Required. An array or cell range of numeric dependent data points.
- Known x's Required. The set of independent data points.
See in this example as we are typing the formula it is being guided by excel with the comments below the slope function written as SLOPE(KNOWNY’S,KNOWNX’S) So the formula will be:
The final contents in the sheet with results is like:
Please find attached the Excel file for reference.
To continue pls check how to insert Slope Graph tutorial.