ExcelFunctions.net

Excel Slope Function

Related Function:
Home » Excel-Built-In-Functions » Excel-Statistical-Functions » Excel-Slope-Function

Slope Equation
The Excel Slope Function uses the following equation to calculate the slope of the linear regression line through a set of given points:
Equation for the slope of a linear regression line
and the values of   x   and   y   are the samples means (the averages) of the known_x's and the known_y's.

Basic Description

The Excel Slope function calculates the slope of the linear regression line through a supplied set of x- and y- values.

The syntax of the function is :

SLOPE( known_y's, known_x's )

Where the arguments are as follows :


known_y's - An array known y-values
known_x's -

An array of known x-values.

Note that the length of the known_x's array should be the same length as known_y's, and the variance of the known_x's must not be zero.

Slope Function Example

The spreadsheet below shows an example of the Excel Slope function used to calculate the slope of the linear regression line through the known_x's and known_y's, in cells F2:F7 and G2:G7. The known_x's and known_y's are also plotted on the simple spreadsheet chart.

Example of use of the Excel Slope Function

The above example gives the result 4.6285714.


Further examples of the Excel Slope function can be found on the Microsoft Office website

Slope Function Errors

The most common errors from the Excel Slope function are listed below :

Common Errors
#N/A - Produced if the supplied known_x's and known_y's arrays are of different lengths.
#DIV/0! - Produced if the variance of the supplied known_x's evaluates to zero or if either of the supplied known_x's or known_y's arrays is empty