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.
16 Replies
Based on screenshot it's hard to check which formulas and how do you use, better to have sample file. Variants could be
- 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.
- Yes, but it has a copy of the matrices attached.
