Finance Train Logo
Register / Login

Using LINEST() Function in Excel for Multivariate Regression

The LINEST() function calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data, and returns an array that describes the line. Because this function returns an array of values, it must be entered as an array formula.

The equation for the line is y = mx + b or y = m1x1 + m2x2 + ... + b (if there are multiple ranges of x values) where the dependent y value is a function of the independent x values.

Create Your Free Account

Create a free account to access this content and join our community of learners.

You'll get access to:

  • Access the full tutorial
  • Join our learning community
  • Track your progress
  • Bookmark content for later
01
Introduction to Linear Regression
02
Standard Error of Estimate (SEE)
03
Coefficient of Determination (R-Squared)
04
Sample Regression Function (SRF)
05
Ordinary Least Squares (OLS)
06
Standard Error in Linear Regression
07
ANOVA Table in Regression
08
Using LINEST() Function in Excel for Multivariate Regression

Topics

Statistical Methods