Forum Discussion
LINEST Mystery output
I have a small, simple table. I'm trying to do a simple multiple linear regression analysis. I get a single digit as a result. Here's the table and output. Here's the formula I used: =LINEST(D1:D10,A...
SergeiBaklanMy understanding (from the Help file) is that the first parameter is the "Y" column, i.e., the dependent variable, hence, LINEST(D1:D10,A1:C10,TRUE,TRUE). "X" variable, i.e., independent variables per the Help file are the second parameter, i.e., LINEST(D1:D10,A1:C10,TRUE,TRUE). In that I haven't received the results promised in the Help file, I don't know if I need the regression stats array, but I'm guessing it contains valuable information about the strength of the correlations, etc.
I see, thank you. Perhaps you are on Excel without dynamic arrays, in this case you shall use Ctrl+Shift+Enter, step by step tutorial for such is here Excel LINEST function with formula examples (ablebits.com)
On modern Excel it looks like