SLOPE function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Spreadsheet Lookup functions
Measures of dispersion / spread
Probability and statistics
Correlation and line fitting
See also (in the Arrays Functions category); GROWTH, LINEST, LOGEST, TREND
Ranking
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
SLOPE
Fits a straight line to data using linear regression and returns its slope.
Syntax:
SLOPE(yvalues; xvalues)
- yvalues and xvalues are single row or column ranges specifying points in a set of data. yvalues and xvalues must be the same size.
- SLOPE fits a straight line through these data points, using the linear regression method (least squares). It then returns the slope of that line.
- The equation of a straight line may be given as y = a + bx. The linear regression method calculates:
- and
- b is the slope, returned by this function.
- Advanced topic:
- The parameters xvalues and yvalues are always evaluated as array formulas.
Example:
SLOPE(B2:B6; A2:A6)
- where the x values in A2:A6 are 1, 2, 3, 4, 5 and the y values in B2:B6 are 2, 4, 6, 8, 11 returns 2.2. The equation of the straight line found is very nearly y = 2x - thus the slope is very nearly (but not quite) 2.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}