Follow these steps to use the INTERCEPT or SLOPE functions in Exccel:
- Open the Excel spreadsheet that contains the data you want to use to calculate the slope or intercept.
- Enter the ‘Slope’ or ‘Intercept’ function in the formula bar followed by the data range for both variables.
- Select the entire range that contains your data.
- Press ‘Enter’ to calculate the slope or the intercept.