LINEST function

Category: Statistical
Introduced: Excel 2003

Summary

Returns the parameters of a linear trend

Syntax

LINEST(known_y's, [known_x's], [const], [stats]) The LINEST function syntax has the following arguments:

Example

=LINEST(A2:A5,B2:B5,,FALSE)
=SUM(LINEST(B1:B6, A1:A6)*{9,1})
=LINEST(E2:E12,A2:D12,TRUE,TRUE)

Microsoft Support Page

https://support.microsoft.com/en-us/office/linest-function-84d7d0d9-6e50-4101-977a-fa7abf772b6d

Back to Functions