Jun 15 2021 02:37 AM
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.
Jun 15 2021 02:54 AM
Jun 15 2021 04:56 PM
Jun 16 2021 01:38 AM
Based on screenshot it's hard to check which formulas and how do you use, better to have sample file. Variants could be
Jun 16 2021 03:34 PM
Jun 17 2021 04:36 AM - edited Jun 17 2021 04:37 AM
@vicvanlint , yes, better to play with spreadsheet. Replying on post you shall see at the bottom
browse the file to attach it.
Jun 17 2021 07:17 AM
Jun 17 2021 07:31 AM
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.
Jun 17 2021 04:44 PM
Jun 19 2021 05:28 AM
Sorry, in your file AD35 is empty, in Z25 is MINIVERSE entered as array formula and in AE25 is MMULT, also entered with CSE
If re-enter formulas without CSE the result is
Jun 19 2021 07:47 AM
Jun 19 2021 01:29 PM
Sorry, but I see only one file from you (which we are discussing)
Jun 20 2021 07:22 AM
@Sergei Baklan I'll try again
Jun 20 2021 07:25 AM
Jun 20 2021 09:22 AM
Thank you for the file. In the formula there is implicit intersection operator "@" which returns first element of the array
If use formula without it result will be expected matrix.
Operator could appear if open in older Excel the file created in Excel which supports dynamic arrays.
Jun 20 2021 10:17 AM
Jun 20 2021 10:56 AM
My respect.
No, inserting of implicit intersection operator is not configurable. Maybe something is in registry settings, but I don't know about such.
On the other hand this operator appears if you open created in old Excel file in new one to ensure compatibility. Old Excel performs implicit intersection silently in background, to have same result in new Excel you shall use this operator.
More about that is here Implicit intersection operator: @ - Office Support (microsoft.com)