vert line

The Matrix sub-menu contains Mesa's matrix manipulation commands. These commands can be used to perform various operations on matrices. 

Regress performs linear regression on the input range. Place your matrix numbers in a range on the worksheet with the x values in the leftmost columns, and the y value in the second to last column, with empty column next to the y values for the output. Highlight the range, and select the command. The results of the linear regression will be calculated and placed in the right-hand column. 

Invert will calculate the inverse of a matrix. Highlight the matrix that you wish to find the inverse of, and a range of equal size immediately to the right of it. When you execute the invert command, the inverse of the matrix will be placed in the empty cells to the right of the original matrix. Only square matrices may be inverted.

Also go to:

Index help

Contents help