LINEST

Definition: LINEST is a function that calculates the parameters of a linear regression line for a given set of data.

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

Situation: This formula is appropriate when you need to calculate the parameters of a linear regression line for a given set of data.

Example: If you have a set of known x and y values, the slope and y-intercept of the regression line can be found using the formula =LINEST(B1:B10, A1:A10, TRUE, TRUE).