To add the r square value to the graph click the Display R-squared value on chart check box. SLOPE Formula includes two arguments. See above screen shot.
We will tabulate our data in two columns.
06 SLOPE1234 10111213 Result. For linear regression Microsoft Excel provides special functions to get the slope and intercept coefficients. B intercept y- mx where b is Intercept. Suppose we have the Xs values located in the excel sheet range from A1 to A10 and Ys values located in the given excel sheet from range B1 to B10 then we can calculate the SLOPE here by using the below VBA functions.