Your data analysis solution

Matrix operations with Excel tutorial

2019-06-24

This tutorial shows how to perform matrix operations (product, addition or subtraction) in Excel using the XLSTAT software.

Dataset for matrix operations

An Excel sheet with both the data and the results can be downloaded by clicking on the button below:
Download the data

The data used here are two matrices A and B. Matrix A is a square matrix with 4 rows and 4 columns and matrix B has 4 rows and 6 columns. Matrix A is invertible to illustrate the possibility to compute inverse of a matrix.

Goal of this tutorial

The aim here is to show a simple example of how to compute the product of two matrices.

Setting up matrix operations in XLSTAT

Select the XLSTAT / Mathematical tools/ Matrix operations feature.


The Matrix operations dialog box appears.

Matrix operations dialog box in XLSTAT
In the General tab, select the data from Matrix A, then select the Inverse option. Then activate Matrix B and select the data corresponding to this matrix from the Excel sheet. Finally, choose to perform the product between the inverse of A noted A^(-1) and Matrix B. The formula is displayed within the dialog box in the Result field.

Results of matrix operations in Excel using XLSTAT

The product of the inverse matrix A and the matrix B is displayed in a new sheet as follows:

This simple example helped us see how to quickly perform matrix operations using XLSTAT. Here, we computed the product of two matrices, but addition and subtraction are also possible on both raw or processed matrices (transpose, inverse).

Contact Us

Email Sales

Contact our technical support team: support@xlstat.com

https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/portal/articles/autocomplete
9283