Hi,

I am trying to code a program in VBA that will calculate the SSE for a set of response variables(Y values) and corresponding explanatory variables(Xs) - among many other things!

Because I realized that LINEST has a max number of explanatory variables of only 17, I decided to use matrix multiplication to compute the values I needed.

What I discovered while doing this was that there are some matrices that LINEST seemed to be able to get values for, but when I tried performing the calculations using matrices - the X'X matrix was not invertible

So my question is - how can LINEST accurately calculate its output?

Does this make sense?

Thank you SO much for any help in advance