Matrix Operations Tool

Real Statistics Data Analysis Tool: The Real Statistics Resource Pack provides the Matrix Operations data analysis tool, which supports a number of matrix operations. These work just like the corresponding worksheet array functions TRANSPOSE, MINVERSE, etc. (see, for example, Matrix Operations), except that you don’t need to specify the shape and size of the matrix since these are determined automatically from the shape and size of the input matrix.

Example

Example 1: Perform all the operations supported by the Matrix Operations data analysis tool for the matrix in range A3:C5 of Figure 1.

After pressing Ctrl-m and selecting the Matrix Operations option (from the Desc tab if using the MultiPage user interface), a dialog box appears as shown on the right side of Figure 1. Next, click on all the options as shown in the figure.

Data and dialog box

Figure 1 – Data and dialog box

After clicking on the OK button, the results shown in Figures 2, 3, 4, and 5 appear (slightly reformatted).

Output

Basic Matrix Operations

Figure 2 – Output from Matrix data analysis tool (part 1)

Matrix output part 2

Figure 3 – Output from Matrix data analysis tool (part 2)

Matrix output part 3

Figure 4 – Output from Matrix data analysis tool (part 3)

Matrix output part 4

Figure 5 – Output from Matrix data analysis tool (part 4)

Examples Workbook

Click here to download the Excel workbook with the examples described on this webpage.

References

Cliff Notes (2021) Operations with matrices
https://www.cliffsnotes.com/study-guides/algebra/linear-algebra/matrix-algebra/operations-with-matrices

Better Solutions (2021) Matrix functions
https://bettersolutions.com/excel/functions/matrix-category.htm

2 thoughts on “Matrix Operations Tool”

  1. I am using the eigenvalue and eigenvectors operator of Real Statistics.
    I wonder what in the screenshot and output tables above (Figure 2) is the interpretation of cells E40 : G41 which are always 0 and the cells E50 : G51 which after rounding are also always 0.
    Or are they only redundant information in the output table?

    Jan

    Reply

Leave a Comment