Manuals/calci/SLOPE
SLOPE(ky's,kx's)
Where ky's is an array or cell range of numeric dependent data points and Kx's is the set of independent data points.
It calculates the slope of the linear regression line through data points in ky's and kx's.
The equation for the slope of the regression line is:
where x and y are the sample means AVERAGE(kx’s) and AVERAGE(ky’s).
SLOPE
=SLOPE(B2:B8,C2:C8) is 0.3993
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 16 | 0.3993 | |
| Row2 | 6 | 12 | ||
| Row3 | 9 | 8 | ||
| Row4 | 10 | 5 | ||
| Row5 | 18 | 17 | ||
| rOW6 | 4 | 9 | ||
| Row7 | 3 | 9 |
