TREND

Syntax

TREND(known_y's, [known_x's], [new_x's], [const])

Parameters

• known_y's: Required. The set of y-values
• known_x's: Optional. The set of x-values
• new_x's: Optional. New x-values for which TREND returns corresponding y-values
• const: Optional. TRUE to calculate b normally (default), FALSE to set b = 0

Example

=TREND(A1:A10, B1:B10)