LINEST
Parameters of the least-squares linear fit.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Array
Examples
=LINEST(A1:A10) | A | |
|---|---|
| 1 | 10 |
| 2 | 20 |
| 3 | 30 |
| 4 | 40 |
| 5 | 50 |
Result -3.3333333333333335
Syntax
LINEST(known_ys, [known_xs], [const], [stats])known_ys- range required
known_xs- range optional
const- boolean optional
stats- boolean optional defaults to
0
Errors
#VALUE!=LINEST(2)