Forum Discussion
MINVERSE works sometimes on Excel 365, but produces only 1 output on most
On my Excel 365 on Windows 10, MINVERSE works correctly on a 4x4 matrix for a cubic regression, but produces only one output entry for a 3x3 matrix for a quadratic regression to the same data set.
Something very strange is happening, unless my age has turned me senile. I worked extensively with Excel 20 years ago, when it didn't insert things I didn't type. I've just used the matrix you use. Without the braces I get a single entry of 6.49852. With braces I get just the formula, i.e., it doesn't recognize the = sign. When I first used MINVERSE successfully it inserted the braces for me, outside the = sign, I think. I could send the entire spread sheet, but now I don't know where to attach it.
vicvanlint , yes, better to play with spreadsheet. Replying on post you shall see at the bottom
browse the file to attach it.
Thank you for the file.
Again, we speak about Excel 365 which supports dynamic arrays.
Your formula (in grey) was entered with Ctrl+Shift+Enter, thus returns only first element of the array. If enter as regular formula as sum of two MINIVERSE matrixes, or step by step, formula returns the matrix. #N/A appears since you use sum of matrixes with different dimensions.
Please check in attached file.
- I'm sorry, but the spread sheet had a lot of irrelevant stuff from my attempts to diagnose the problem and unintentional Excel inserts, which distracted you from the relevant section. The relevant part is the sections labeled Cubic Fit and Quadratic Fit which show the square matrix and vector with the MINVERSE command below. Please ignore anything to do with matrix addition. AE25 is the location of the output vector that was there when MINVERSE worked previously, and AD35 is the one-cell output of a MINVERSE command without braces.