If omitted, it will be assumed to be a set of the same size as known-y-valuesbeginning with 1-for example, 1, 2, 3 if there are three known-y-values. known-x-values must contain number values. known-x-values: An optional collection containing the known x values.If there is more than one collection of known x values, known-y-values can be either one column containing the values or one row containing the values, but not both. If there is only one collection of known x values, known-y-values can be any size. known-y-values must contain number values. known-y-values: A collection containing the known y values.LINEST( known-y-values, known-x-values, nonzero-y-intercept, more-stats) The LINEST function returns an array of the statistics for a straight line that best fits the given data using the least squares method. So you have to embed the lines function into a call to index() in order to access the elements of the array. When you type the equal sing in a cel, you enter 'formula mode' and the function browser appears on the right:Įnter the function in question in the search field.
I suggest reviewing the built-in function browser information.
