Excel - Microsoft Excel slope Function

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 : 

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. 

Slope Function Errors

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

Common Errors