|
To make things clearer: TREND and LINEST are functions that can be used to be used for least sq. linear regression, but in the classic way errors at all points in the x axis are given equal weight. (the sum of the squares all these errors is optimised (/minimised) to find the best coefficient)
|