Matrix multiplication

Feature requests
1

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

2

Hi Eiffel,

I guess, unpivoting + merging + multiplying + pivoting back should be equivalent to matrix multiplication, no?

3

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)

image
image1210×628 27.7 KB

4

Thanks Dmitry for the quick help! Yes, I am able to replicate this logic into covariance matrix.