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”?

@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