Menu
EXCEL SLOPE FUNCTION
Excel SLOPE Function Introduction
The Excel Slope function computes the slope of a trend line given a collection of x- and y-values.
Description of Excel SLOPE Function
Syntax :
=SLOPE( known_y’s, known_x’s )
Parameters :
- The following parameter are:
known y’s –
- A collection of known y-values.
known x’s –
- A collection of known x-values.
Step By Step Guide of SLOPE Function
Example :
The spreadsheet below illustrates when to use the Spreadsheets Steep process to determine the slopes of the linear regression line across the known x’s and known y’s in cells F2:F7 and G2:G7.
A Gradient method employed, as indicated in cell F9, is:
Key Points
- #N/A – Occurs if the widths of the given known x and known y arrays disagree.
- #DIV/0! – Occurs if either the variance of the given known x’s equals zero or even one of the provided known x’s or known y’s arrays is empty.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
