Identity Matrix – creates an identity matrix of the specified size.Hessenberg Factorization– finds the Hessenberg Decomposition of a square matrix, which is equal to Q THQ where Q is an orthogonal matrix and H is a Hessenberg matrix.LU Factorization– finds the LUP Decomposition of a square input matrix, which is equal to P TLU where P is a permutation matrix, L is a lower triangular matrix and U is an upper triangular matrix.Spectral Factorization – finds the Spectral Decomposition of a symmetric input matrix which is equal to QDQ T where D is a diagonal matrix and Q is an orthogonal matrix.SVD Factorization – finds the Singular Value Decomposition (SVD) consisting of diagonal matrix D and orthogonal matrices U and V where input matrix = UDV T.Schur Factorization – finds an orthogonal matrix Q and upper triangular T such that the input matrix = QTQ T.QR Factorization – finds an orthogonal matrix Q and upper triangular R where the input matrix = QR.
Eigenvalues and Eigenvectors – finds the eigenvalues and eigenvectors of a symmetric square input matrix.Diagonal – creates a diagonal matrix with specified diagonal.Covariance Matrix – creates the population or sample covariance matrix for the specified data range.Correlation Matrix – creates the correlation matrix for the specified data range.Remove rows with non-num cell(s) – remove any row with a non-numeric cell.Remove rows with empty cell(s) – remove any row with an empty cell.Sort by rows – sort rows based on the value of the cell in a selected column.Copy exact formulas – copy a range to a new location without changing the cell addresses.Remove error cells – replace any error cells by empty cells.Remove non-numeric cells – remove all cells with non-numeric data.Remove blank cells – remove all empty cells.Randomize – randomly select data from data range (with replacement).
Shuffle – randomly permute the data (selection without replacement).Sort without duplicates – reproduce the data in sorted order removing duplicates.Sort – reproduce the data in ascending sorted order.