Learn How to Use Microsoft Excel SLOPE Function

Microsoft Excel SLOPE Function

The main purpose of the Microsoft Excel SLOPE function is to get the slope of linear regression line. That implies, with the help of SLOPE function you can able to return the slope of a regression line based on known "y" values and known "x" values. It should be noted that the regression line is a "best fit" line based on known data points. So, with the help of the SLOPE function, you can able to get the slope of the linear regression line.

Return Value of SLOPE Function

The return value will be the calculated slope of the number.

Syntax of SLOPE Function

=SLOPE(known-ys, known-xs)

Where the arguments:

• known-ys: This is the range or array of numeric data points which are dependent values.
• known-xs: This is the range or array of numeric data points which are independent values.

How to Use Microsoft Excel SLOPE Function?

So we know that Microsoft Excel SLOPE function you can able to get the slope of a linear regression line. That implies, with the help of SLOPE function you can able to return the slope of a regression line based on known "y" values and known "x" values. It should be noted that the regression line is a "best fit" line based on known data points. So, with the help of the SLOPE function, you can able to get the slope of a linear regression line.

Check out the list of all other articles:

• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel
• Learn How to Sort Birthdays by Month and DAY in Microsoft Excel