Documentation/Calc Functions/SLOPE

From The Document Foundation Wiki
Jump to navigation Jump to search


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 (β) is:
Forecast n.png

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

y = α + βx

where

α = ӯ - βx̄.

  • For more details on the slope of a linear regression line, visit Wikipedia.

Examples:

DataY DataX
1 195 200
2 151 180
3 148 178
4 189 165
5 183 192
6 154 144
Formula Description Returns
=SLOPE(A1:A6;B1:B6) Calculates the β parameter value expected for a linear trend based on the data. 0.496617389125532
=SLOPE({8,9,10,11};{50,80,110,140}) Calculates the β parameter value expected for a linear trend based on the data passed as array. 0.033333333333333

Related LibreOffice functions:

INTERCEPT

LINEST

STEYX

ODF standard:

Section 6.18.69, part 2

Equivalent Excel functions:

SLOPE