Computes a matrix diagonal.
DIAGONAL(a, n)
a |
- |
A series or matrix. |
||||||
n |
- |
Optional. An integer, the diagonal number:
|
A series or square matrix.
W1: {1, 2, 3}
W2: diagonal(W1)
returns: {{1, 0, 0},
{0, 2, 0},
{0, 0, 3}}
W3: diag(W2)
returns: {1, 2, 3}
W4: diag(W2, 1)
returns: {0, 0}
diagonal(series) returns a square matrix where the diagonal of the resulting matrix has the same values as the input series.
diagonal(matrix, n) returns a single column series where the values are the diagonal of the input matrix. n specifies the optional diagonal number.
DIAGONAL can be abbreviated DIAG.