With just two variables, this is a really minor issue. Instead of the more natural and more easily interpreted: So if you wanted to use the regression equation to estimate the income of the first person in Row 2, you would need to use this formula (parentheses included for clarity only): ![]() (The intercept, in cell G5 in Figure 1, always appears rightmost in the LINEST() results.) But in the underlying data set, the Education data (column A) precedes the Age data (column B). The problem is that the regression coefficient for Age is in cell E5, and the coefficient for Education is in cell F5: in left-to-right order, the coefficient for Age comes before the coefficient for Education. ![]() Only by setting the third argument to FALSE can you force LINEST() to remove the constant from the regression equation. ![]() You can also omit the argument and Excel regards that as setting it to TRUE: LINEST()'s third argument, called const, is set to TRUE in the example just given.
0 Comments
Leave a Reply. |