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