Regression Output of Linest

Copper Contributor

I have carried out regression on a set of data using LINEST. But I can't identify the Betas and Constant as I don't know what is the order of the result.

 

Could someone mention what is the order of result according to the attached file?

1 Reply
If you select the cell with the LINEST function and click the Fx button to the left of the formula bar, the next screen has a link to the help file on LINEST: https://support.office.com/en-us/article/linest-function-84d7d0d9-6e50-4101-977a-fa7abf772b6d?NS=EXC...