LINEST
Description
Returns information on the line that best fits the specified x values and y values.
Syntax
LINEST(
known_ys
, [
known_xs
], [
const
], [
stats
])
- known_ys: The array of x values.
- known_xs: The array of y values.
- const: Specifies how to handle the constant b. FALSE or Empty = the value is zero; TRUE = treat it normally.
- stats: Specifies whether to return more regression information about the best fitting line. FALSE or Empty = do not return more information; TRUE = do return more information.