3 ms·
Excel may be one of the mostly widely used programs for data analysis, because so much data is in spreadsheets and so many people use them. But multiple linear
by Bostonian 5y ago
Excel may be one of the mostly widely used programs for data analysis, because so much data is in spreadsheets and so many people use them.
But multiple linear regression using LINEST returns the coefficients in the opposite order of the data. See https://www.excelforum.com/excel-general/353071-linest-why-did-they-do-that.html https://www.excelforum.com/excel-general/353071-linest-why-d... . Has Microsoft fixed this? At least offering an optional argument to LINEST to get coefficients in the same order as the columns? The stupid ordering of LINEST results has cost me and many other people countless hours over the years.