# Why covariation matrix is recorded with only lower diagonal part

Hello. I understand that the covariation matrix is symmetric but is there any way to print not only the lower diagonal part of it when I use Calc statistics? I need that matrix for my evaluations and I have to compute for example product A * x, where A is my covariation matrix and x - some vector but LibreOffice doesn’t permit to produce that operation with matrix which is not recorded like m * n table.

Would you mind to tell us what function / formula you used to calculate / output the “covariation matrix”?
Neither my (incomplete) knowledge of statistics nor en.wikipedia.org nor reference.wolfram.com are mentioning such a thing, OpenFormula and LibO help not to talk of.
Did you probably mean a “correlation matrix”? A “covariance marix”?

@Lupp There is information here

@peterwt: I knew that page. Thanks nonetheless.
Did you find something about “covariation” or do you assume (as I did) “covariance” was meant most likely?
Do you have an idea what formula / tool was used to create the triangular matrix?
There is no standard function for the purpose as far as I can see and the only statistical extension I found is old and “version 0.0.” Of course, we may use COVAR once per a pair of n variables, but he who does it is responsible for the arrangement then.

Given a square matrix in, say E4:G6, assured to be triangular (either left-lower OR right-upper)
`{=E4:G6+TRANSPOSE(E4:G6)-MUNIT(ROWS(E4:G6))*E4:G6}`, entered for array evaluation will return the symmetric completion.
Be sure to regard that there may be statistics tools understanding correlation/covariance matrices as “triangular by definition”. Such a tool may go wrong if getting passed a symmetric matrix instead.

(Editing to explain my remark “Of course, we may use COVAR once per a pair of n variables, but he who does it is responsible for the arrangement then.” from my answer to the comment by @peterwt to the OQ:)
See this demo. For large and many data columns efficiency is asymptotically doubled for a solution only calculating a triangular matrix and then filling it up symmetrically.

Your formula works. Thank you very much!

@remagin: Are you sure there is a good reason not to answer the question from my comment to your OP?
This is not a one-way lane! And I am not paid for servicing selfish users.
Again: What formula or tool did “record …{a matrix} … with only lower diagonal part”?

@this demo :

``````=COVAR(INDEX(data;;MATCH(\$G14;header;0));INDEX(data;;MATCH(H\$13;header;0)))
``````

pull to right and down.
leave the Ranges “behind” the Names `data` and `header` open, as challenge for the audience