Skip to main content
MedCalc
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
working
Show menu Show menu

Matrices

A matrix is a rectangular array of real and/or complex numbers arranged in rows and columns. A r × c matrix has r rows and c columns. The whole numbers r and c are the dimensions of the matrix. The individual items in the matrix are elements. The element on row r and column c is identified with er,c.

In the literature, matrices are commonly denoted by a boldface uppercase character, e.g. A.

A r × 1 matrix is a called a column matrix, and a 1 × c matrix is a row matrix. A 1 × 1 matrix is called a scalar. A matrix with a single row or a single column is sometimes called a vector.

A matrix with the same number of rows and columns is called a square matrix.

An identity matrix or unit matrix is a square matrix in which all the elements of the principal diagonal are ones and all other elements are zeros. The effect of multiplying a given matrix by an identity matrix is to leave the given matrix unchanged.

A zero matrix is a matrix where all elements are zero.

A diagonal matrix is a square diagonal matrix with all elements that are not on the principal diagonal, equal to zero.

To make a distinction between matrices that contain real numbers and matrices that contain complex numbers, the term real matrix or complex matrix is used.

In the MedCalc spreadsheet a matrix is represented in a single cell as a list of values between curly brackets with values on the same row separated with a comma (or your local list separator symbol) and rows are separated with a vertical bar. For example, the textual representation of the matrix

56
78

is {5,6|7,8}.

For large matrices, when not all values can be displayed in a single cell, the values that cannot be displayed are represented with 3 dots. For example, the identity matrix with 12 rows and 12 columns will be textually represented as:

{1,0,0,0,0,0,0,0,0,0,0,0| 0,1,0,0,0,0,0,0,0,0,0,0| 0,0,1,0,0,0,0,0,0,0,0,0| 0,0,0,1,0,0,0,0,0,0,0,0| 0,0,0,0,1,0,0,0,0,0,0,0| 0,0,0,0,0,1,0,0,0,0,0,0| 0,0,0,0,0,0,1,0,0,0,0,0| 0,0,0,0,0,0,0,1,0,0,0,0| 0,0,0,0,0,0,0,0,1,0,0,0| 0,0,0,0,0,0,0,...}

Create a matrix from data

To create a matrix from existing data, use the { } operator as follows:

Create a matrix from variables in the spreadsheet

{variables list} returns a matrix containing the data of all cases in the spreadsheet for several variables. The number of columns is the number of variables in the variables list, and the number of rows is the number of cases.

When var1, var2 and var3 are variables in the spreadsheet, then {var1,var2,var3} will return a n × 3 matrix where n, the number of rows in the matrix, is the total number of cases that do not have missing data for var1, var2 or var3.

The resulting matrix may contain missing data. To remove empty columns and rows with missing data, use the CLEAN function.

Create a matrix from a spreadsheet range

{range} creates a matrix containing all data in the specified spreadsheet range. The data range can contain missing data.

{a1:b20} creates a 20 × 2 matrix containing the data in spreadsheet cells A1 to B20.

Create a matrix from a data list

{v11, v12, ... | v21, v22, ...} returns a matrix containing the data listed in the argument list. The elements on the same row are separated with a comma (or your local list separator symbol), and the rows are separated with a vertical bar | (for convenience you can also use ! or \ as a row separator, MedCalc will convert it to | automatically).

The matrix may contain missing data. The entries in the data list may be numbers or cell references.

{5,6|7,8} creates the following 2 × 2 matrix:

56
78

{5,6|7,8,9} creates the following 2 × 3 matrix:

56
789

To indicate an empty row, use two vertical bars |  | separated with a space, e. g. {5,6|  |7,8,9}

56
 
789

Since the length of the text in a MedCalc cell is limited to about 250 characters, this method does not allow to create large matrices.

Basic mathematical operations

Sign reversal
AA minus sign placed in front of a matrix reverses the sign of each element.
Multiplication or division of a matrix with a real number
A * reach element of matrix A is multiplied by the real number r
A / reach element of matrix A is divided by the real number r
Addition or subtraction of a matrix with a real number
A + rthe real number r is added to each element of matrix A
Arthe real number r is subtracted from each element of matrix A
Addition or subtraction of matrices
A + BThe corresponding elements of the two matrices are added. The matrices must have the same dimensions (*)
ABThe corresponding elements of the two matrices are subtracted. The matrices must have the same dimensions (*)
Elementwise multiplication
A &* BThe corresponding elements of the two matrices are multiplied. The matrices must have the same dimensions (*)
Elementwise division
A &/ BAll elements of matrix A are divided by the corresponding elements of matrix B. The matrices must have the same dimensions (*)
Multiplication of matrices
A * B If A is an n × m matrix and B is an m × p matrix, A*B is an n × p matrix in which the element in row i, column j, is equal to
$$ (\mathbf{A}\mathbf{B})_{ij} = \sum_{k=1}^m A_{ik}B_{kj} $$
Matrix multiplication requires that the number of columns of the first matrix equals the number of rows of the second matrix
Division of matrices
A / BMatrix A is multiplied with the inverse of matrix B

(*) if one of the matrices is a m × n matrix and the other matrix is a column vector m × 1, then the elements of the column vector are added (resp. subtracted, multiplied, divided) to the corresponding elements of each column of the m × n matrix. If one of the matrices is a m × n matrix and the other matrix is a row vector 1 × n, then the elements of the row vector are added (resp. subtracted, multiplied, divided) to the corresponding elements of each row of the m × n matrix.

Accessing individual elements, rows or columns

Individual elements, rows or columns can be accessed using the INDEX function.

For example, if cell A1 contains the matrix {4,5,6|7,8,9}, then

INDEX(A1,2,2) returns 8

INDEX(A1,0,2) returns the column matrix {5|8}, the 2nd column of the matrix in A1

INDEX(A1,2,0) returns the row matrix {7,8,9}, the 2nd row of the matrix in A1

Alternatively, you can use the following syntax: A1[r,c]

A1[2,2] returns 8 (in the spreadsheet, you have to precede this formula with the = sign, because the formula starts with a cell address).

Matrix functions

MedCalc provides a large number of functions for matrix creation, removing and adding of columns and rows, matrix properties, matrix operations and transformations, and linear equations.

See Matrix functions.

Mathematical functions on matrices

The following functions accept a matrix or data range as argument, in which case they return a matrix as result.

When a mathematical function is applied to a matrix, then the function is applied to all its individual elements.

Mathematical functions:

Abs, Log, Ln, Exp, Pow10, Sqrt, Square, Int, Rand, Sign, Odd, Abs, Trunc, Ceil, Floor,

Logit, Alogit,

Erf, Erfc

Fact, Gamma, GammaLN

Trigonometric functions:

Sin, Cos, Tan, Asin, Acos, Atan, SinH, CosH, TanH, AsinH, AcosH, AtanH, Radians, Degrees

Sinintegral, Cosintegral,

For functions that require 2 arguments (such as Power, Mod, Round, RandNorm, Atan2), when both arguments are matrices, these matrices must have the same number of rows and columns.

Power, Mod, RandNorm, Round, Atan2,

Beta,

BesselJ, BesselI, BesselY, BesselK

Statistical functions on matrices

When one of the following statistical spreadsheet functions is applied to a matrix, a row vector is returned that contains the statistic for the data in each corresponding column of the matrix.

The following functions can be used on real matrices:

AVEDEV, AVERAGE, COEFVAR, COUNT, COUNTNEG, COUNTPOS, GEOMEAN, HARMEAN, MAX, MEDIAN, MIN, PERCENTILE, PERCRANK, SEM, STDEV, SUM, SUMNEG, SUMPOS, SUMSQ, TESTNORM, TrimMean, TrimMeanSEM, TrimMeanLOW, TrimMeanHIGH, VAR

The following functions can be used on matrices that contain complex numbers:

AVERAGE, COUNT, SUM

Statistical test functions on matrices

The statistical test functions require the degrees of freedom to be integers, the test values can be matrices.

ChiDist, ChiInv, FDist, FInv, NormsDist, NormsInv, TDist, TInv

See also