The formula 'Variance' returns the variance of a matrix over the rows or the columns of that matrix, depending on the chosen dimension.
The matrix you want to know the variance of.
The dimension to take the variance over. 1 means downwards (over rows), 2 means rightwards (over columns).
In the following example the formula 'Variance' is used to take the variance over the columns.
|Column1 ||Column2 ||Column3 ||Column4 ||Column5 |
|13 ||11 ||17 ||12 ||11 |
|1 ||9 ||4 ||2 ||8 |
As you see the results are the variances of the rows of the matrix.
- Variance: This page describes the variance and it's relation to other statistics.
If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.