Forum Discussion

Copper Contributor

Jan 19, 2021

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...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jan 19, 2021

hAltonJones

It's not clear what you'd like to receive - where is x, where y, and why do you need regression stats array with last parameter. Please check if you are in sync with description LINEST function - Office Support (microsoft.com)

hAltonJones
Copper Contributor
Jan 19, 2021
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.
- SergeiBaklan
  Diamond Contributor
  Jan 19, 2021
  hAltonJones
  
  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