Excel Function : LINEST
Category
Statistical
Description
Returns the parameters of a linear trend
Microsoft Excel Reference Page
https://support.office.com/en-us/article/LINEST-function-84d7d0d9-6e50-4101-977a-fa7abf772b6d
Syntax and Description of the LINEST Excel Function
Syntax: LINEST(y-values, x-values, const, stats) The LINEST function returns information about the linear regression trendline of a set of data. This function is useful for analyzing data that has a linear relationship. y-values: The dependent data points that you want to analyze. x-values: The independent data points that you want to use to predict the dependent data points. const: A logical value that specifies whether to force the constant b0 in the equation to 0. The default value is TRUE. stats: A logical value that specifies whether to return additional statistics about the trendline. The default value is FALSE.
About LINEST Excel Function
The LINEST function in Excel calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data. The function returns an array that describes the line. The syntax for the LINEST function is: =LINEST(known_y_values, known_x_values, const, stats) where known_y_values are the dependent data points, known_x_values are the independent data points, const is a logical value that determines whether the line should be forced through the origin (TRUE) or not (FALSE), and stats is a logical value that determines whether additional statistics should be returned (TRUE) or not (
