Syntax :

=LINEST( known_y’s, [known_x’s], [const], [stats] )

Parameters :

• The following parameter are:

known y’s –

• A collection of known y-values.
  [known x’s] –
• An optional parameter that returns an array containing one or more sets of known x-values.
  If supplied, the [known x’s] array should be the same length as that of the known y’s array; if not provided, the [known x’s] array defaults to 1, 2, 3,…

[const] –

• A persuasion that specifies how the constant ‘b’ is handled in the equation y = m1x1 + m2x2 +… + b.
  This parameter can be TRUE or FALSE, which means that:
• TRUE (or omitted) – the constant b is processed normally;
• FALSE – the constant b is assigned to the value 0.

[stats] –

• An optional logical parameter that defines whether the function should return extra regression statistics on the line of best fit.
  This parameter can be TRUE or FALSE, which means:
• FALSE (or omitted) – if more regression statistics are not returned.
  That is, just return the array of values mn, mn-1,…, b.
• TRUE – Additional regression statistics ARE RETURNED.
  In other words, return the array of values mn, mn-1,…, b as well as the extra regression statistics specified in the table below.