How to Find Slope in Microsoft Excel

Quick summary

The Excel SLOPE function lets you calculate the slope of a linear regression line by supplying known Y and X value ranges directly inside a worksheet cell. This step-by-step walkthrough shows exactly how to locate and run the SLOPE formula through Excel's built-in Formulas menu in under a minute.

Steps

1. In your Microsoft Excel worksheet, select the cell where you want the slope result to appear.
2. Navigate to the top menu bar and click Formulas.
3. Click More Functions from the available options in the Formulas tab.
4. Select Statistical from the submenu that appears.
5. Find and choose Slope from the Statistical functions list.
6. Click the Known_ys input field and type the cell range that contains your Y values.
7. Click the Known_xs input field and enter the cell range that contains your X values.
8. Click Insert to confirm and apply the function.
9. The calculated slope value will be displayed in your selected cell.