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 of result according to the attached file?
1 Reply
- JKPieterseSilver ContributorIf 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