Excel has three built-in functions that allow for a third method for determining the slope y-intercept correlation coefficient and R-squared values of a set of data. 06 SLOPE1234 10111213 Result. The mathematical formula for calculating the slope of known xs and know ys is Where x bar is the mean of the know xs and y bar is the mean of known ys.
To get the intercept and the slope of a regression line you use the LINEST function in its simplest form.
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. We will then highlight our entire. As you can see the equation shows how y is related to x. The value of m is the slope of the graph.