Syntax:
TREND(linest-data:Array|Range, x-data:Array|Range)
Takes the result of a LINEST
function
(the linest-data array)
and applies it to the x-data array (or range of cells)
to return corresponding estimated y-data array.
If x-data is of dimensions m×n
and the LINEST function has returned n+1
coefficients,
then you will get m
output y-data, or vice versa.
Note that the estimated y-data may be very poor quality if any of the
x-data values are beyond the limits of the
x-data supplied to the LINEST
function.