Hi Dmitry,
Just trying to understand if matrix multiplication is on the road map of EasyMorph. That will be essential for calculating correlation matrix. Meantime, not sure if there’s a easy work around to calculate correlation matrix.
Thanks,
Eiffel
Hi Eiffel,
I guess, unpivoting + merging + multiplying + pivoting back should be equivalent to matrix multiplication, no?
Actually, yes, it does the trick. It turned out a bit less trivial than I initially assumed but still doable. See below.
Tested with Matrix Multiplication Calculator.
matrix-multiplication.morph (6.2 KB)
Matrices.xlsx (7.9 KB)
Thanks Dmitry for the quick help! Yes, I am able to replicate this logic into covariance matrix.