LINEST
Returns the parameters of a linear trend.
StatisticalStatistics & Analysis
What it does
Calculates statistics for a line using the 'least squares' method.
Syntax
LINEST(known_y's, [known_x's], [const], [stats])
Arguments
known_y's(range) — Dependent values.known_x's(range) — Independent values.
Examples
Linear Regression
Calculate slope (m) and intercept (b).
FORMULA
=LINEST(B2:B4, A2:A4)
RESULT
[2, 0]
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | X | Y |
| 2 | 1 | 2 |
| 3 | 2 | 4 |
| 4 | 3 | 6 |