LINEST (PQL  xl)
This function calculates the statistics for a line
 Library: PQL \ Spreadsheet \ Statistical
 Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
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 
const  Logical value that specifies whether to force the constant b to equal 0. If true or omitted then b is calculated normally; if false then b is equal to 0 and the m values are adjusted so that y=mx  StringOrNumber 

stats  Logical value that specifies whether to return additional regression statistics. If true, then the additional regression statistics are returned if false or omitted then only the mcoefficients and b are returned  StringOrNumber 

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