known_y's,known_x's,new_x's,const!Returns numbers in a linear trend matching known data points, using the least squares method!is ...

!known_y's,known_x's,new_x's,const!!Returns numbers in a linear trend matching known data points, using the least squares method!is a range or array of y-values you already know in the relationship y = mx + b!is an optional range or array of x-values that you know in the relationship y = mx + b, an array the same size as Known_y's!is a range or array of new x-values for which you want TREND to return corresponding y-values!is a logical value: the constant b is calculated normally if Const = TRUE or omitted; b is set equal to 0 if Const = FALSE!