Su solución de análisis de datos

Matrix operations with Excel tutorial

24/06/2019

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).

Contacto

Email ventas

Contactar con nuestro soporte técnico : support@xlstat.com

https://cdn.desk.com/
false
desk
Cargando
hace #{num} segundos
hace un minuto
hace #{num} minutos
hace una hora
hace #{num} horas
hace un día
Hace #{num} días
sobre
false
Se han encontrado caracteres no válidos
/customer/portal/articles/autocomplete
9283