Documentation/Calc Functions/SLOPE

Function name:
SLOPE

Category:
Statistical Analysis

Summary:
Calculates the slope of the linear regression line using the specified (x, y) points.

Syntax:
SLOPE(DataY; DataX)

Returns:
Returns a real number which is the slope of the linear regression line constructed through data points in DataY and DataX.

Arguments:
DataY is a name, array, or reference to a range of cells containing the Y data.

DataX is a name, array, or reference to a range of cells containing the X data


 * If a cell contains text or empty cells, then the function ignores these values. For logical values, TRUE is considered as 1 and FALSE as 0.
 * If a cell contains 0 then the function includes it.
 * If DataX and DataY have different dimensions, then the function returns an error value.

Additional details:

 * The formula for SLOPE (&beta;) is:

Here x̄ and ӯ are mean values for DataX and DataY, respectively. For a given slope a line is given as

y = &alpha; + &beta;x

where

&alpha; = ӯ - &beta;x̄.
 * For more details on the slope of a linear regression line, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/INTERCEPT INTERCEPT]

[[Special:MyLanguage/Documentation/Calc_Functions/LINEST LINEST]

[[Special:MyLanguage/Documentation/Calc_Functions/STEYX STEYX]

ODF standard:
Section 6.18.69, part 2

Equivalent Excel functions:
SLOPE