TREND (PQL  xl)
This function returns values along a linear trend. This function fits a straight line to the arrays known x and y values. Trend returns the y values along that line for the array of specified new x values
 Library: PQL \ Spreadsheet \ Statistical
 Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
TREND(known ys, OPTIONAL known xs, new xs, const)
Function Arguments
Name  Description  Type  Optional 
known ys  Set of y values that are known in the relationship y=mx+b  StringOrNumber 

known xs  X is an optional set of x values that may be known in the relationship y=mx+b  StringOrNumber  Y 
new xs  New x values for which this function returns the corresponding y values  StringOrNumber 

const  Logical value that specifies whether to force the constant b to equal 0  StringOrNumber 

Comments
This function is the same as the Microsoft Excel 'TREND' function  using the same inputs, logic and outputs.