Forum Discussion
AdityaMahajan
May 12, 2020Copper Contributor
Regression Output of Linest
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 o...
JKPieterse
May 12, 2020Silver Contributor
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=EXCEL&Version=90&SysLcid=1033&UiLcid=1033&AppVer=ZXL900&HelpId=xlmain11.chm60097&ui=en-US&rs=en-US&ad=US