top of page
... but the thing is, there are many an Z matrix configuration’s capable of describing the same spatial phenomenon:
... so, it is mandatory to understand the nature, or the implications of the mathematical matrixial notation ... 
12_matrix_cicle.PNG

Beta μ

Auto-covariances

Cross-covariances

01_abx.png
27.png
28.png

What is variance? The standard deviation multiplied by itself.

But what's standard deviation? The square root of the variance.

Derived form a unique vector the covariance matrix displays all the "spatialized" combinations of pairs of its random elements, although seldom, or not necessarily, in the Euclidian space.

29.PNG

From now on, let's can call the  covariance matrix, this Z Matrix, just "the model".

13_MKV.01.PNG

As an example of data relationships within a square matrix, from the Markovian chain’s transitional probabilities standpoint, let’s see a given database being scaled up in many orders of magnitude.

13_MKV.02.PNG
a25.png

A trick worth to known for the ones less familiarized with the spreadsheet inner works.

To reach a dynamic input / output relation for the transposition tool:

- Select all the arriving locations destinated to receive the data (the horizontal row cells) - Then select the same number of inputs (the vertical column cells).

- Keeping CTRL Alt keyboards keys active, press Enter to execute the command.     

The same routine applies for any matrixial operation.

Use preferably, the downloaded version of all the avaliable spreadsheets.

The last one MS Office Pro Plus 2019  is recommend, but we think the older versions will also work, just fine. 

In order to expand the matrixial functions capabilities in MS Excel, you may need to enable: Solver Add-ins.  

In addiction, download at least the plug-in matrix.xla. Perhaps, XRealStats.xlam too. In Excel, press alt TI and install it. 

bottom of page