# Using matrices

Matrices are rectangular blocks of numbers on which mathematical operations can be conducted.

## Enter data in a matrix

You can create a matrix by typing values or by importing values from a file.

1. Choose Calc > Matrices > Read.
2. Specify the number of rows and number of columns in the matrix.
3. In Read into matix, enter a name or ID for the matrix. Each stored matrix has a unique ID that starts with an M; for example, M1. You can also name matrices as you do columns, for example, M1 = Output, M2 = Historical.
4. Choose one of the following:
Option Description
Read from keyboard Choose to type the values for the matrix.
Read from file Choose to import the values for the matrix from a file.
5. Click OK.
If you chose Read from file, you will be prompted to browse to and select the file that contains the values for the matrix.

## View a matrix

Stored matrices are not displayed in the worksheet.

• To view a stored matrix in the Session window, choose Data > Display Data.
• To view a stored matrix in the worksheet, choose Data > Copy > Matrix to Columns.

## Manipulate a matrix

• Choose Calc > Matrices and choose one of the following commands:
Option Description
Transpose Transpose a matrix so that its rows become columns and its columns become rows.
Invert Calculate the inverse of a square matrix.
Define Constant Create a matrix with the same value in each cell.
Diagonal Create a matrix that has diagonal values from a column in the worksheet, or make a column in the worksheet from the diagonal values of a matrix.
Eigen Analysis Calculate eigenvalues and eigenvectors for a symmetric matrix.
Arithmetic Perform arithmetic operations on matrices.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy