Transporting matrix online calculator. Transposing a matrix in Microsoft Excel

Transposing a matrix through this online calculator will not take you much time, but it will quickly give results and help you better understand the process itself.

Sometimes in algebraic calculations there is a need to swap the rows and columns of a matrix. This operation is called matrix transposition. The rows in order become columns, and the matrix itself becomes transposed. There are certain rules in these calculations, and to understand them and visually familiarize yourself with the process, use this online calculator. It will make your task much easier and help you better understand the theory of matrix transposition. A significant advantage of this calculator is the demonstration of an expanded and detailed solution. Thus, its use promotes a deeper and more informed understanding of algebraic calculations. In addition, with its help you can always check how successfully you completed the task by transposing the matrices manually.

The calculator is very easy to use. To find a transposed matrix online, specify the matrix size by clicking on the “+” or “-” icons until you obtain the desired number of columns and rows. Next, enter the required numbers into the fields. Below is the “Calculate” button - clicking it displays a ready-made solution with a detailed explanation of the algorithm.

In higher mathematics, such a concept as a transposed matrix is ​​studied. It should be noted: many people think that this is a rather complex topic that is impossible to master. However, it is not. In order to understand exactly how such an easy operation is carried out, you only need to become a little familiar with the basic concept - the matrix. Any student can understand the topic if they take the time to study it.

What is a matrix?

Matrices are quite common in mathematics. It should be noted that they are also found in computer science. Thanks to them and with their help, it is easy to program and create software.

What is a matrix? This is a table in which the elements are placed. It must have a rectangular appearance. In simplest terms, a matrix is ​​a table of numbers. It is designated using some capital Latin letters. It can be rectangular or square. There are also separate rows and columns, which are called vectors. Such matrices receive only one line of numbers. In order to understand how big a table is, you need to pay attention to the number of rows and columns. The first is denoted by the letter m, and the second by n.

You should definitely understand what a matrix diagonal is. There is a side and a main one. The second is that strip of numbers that goes from left to right from the first to the last element. In this case, the side line will be from right to left.

With matrices you can do almost all the simplest arithmetic operations, that is, add, subtract, multiply with each other and separately by number. They can also be transposed.

Transposition process

A transposed matrix is ​​a matrix in which the rows and columns are swapped. This is done as easily as possible. Denoted as A with superscript T (A T). In principle, it should be said that in higher mathematics this is one of the simplest operations on matrices. The table size is maintained. Such a matrix is ​​called transposed.

Properties of transposed matrices

In order to correctly perform the transposition process, it is necessary to understand what properties of this operation exist.

  • There must be an original matrix for any transposed table. Their determinants must be equal to each other.
  • If there is a scalar unit, then when performing this operation it can be taken out.
  • When a matrix is ​​double transposed, it will be equal to the original one.
  • If you compare two folded tables with swapped columns and rows with the sum of the elements on which this operation was performed, they will be the same.
  • The last property is that if you transpose tables multiplied with each other, then the value must be equal to the results obtained by multiplying the transposed matrices together in reverse order.

Why transpose?

A matrix in mathematics is necessary in order to solve certain problems with it. Some of them require you to calculate the inverse table. To do this, you need to find a determinant. Next, the elements of the future matrix are calculated, then they are transposed. All that remains is to find the directly inverse table. We can say that in such problems you need to find X, and this is quite easy to do with the help of basic knowledge of the theory of equations.

Results

This article examined what a transposed matrix is. This topic will be useful to future engineers who need to be able to correctly calculate complex structures. Sometimes the matrix is ​​not so easy to solve, you have to rack your brain. However, in the course of student mathematics, this operation is carried out as easily as possible and without any effort.

Transposing matrices

Matrix transposition is called replacing the rows of a matrix with its columns while maintaining their order (or, which is the same, replacing the columns of a matrix with its rows).

Let the original matrix be given A:

Then, by definition, the transposed matrix A" has the form:


A shortened form of notation for the operation of transposing a matrix: A transposed matrix is ​​often denoted

Example 3. Let matrices be given A and B:


Then the corresponding transposed matrices have the form:

It is easy to notice two patterns of the matrix transposition operation.

1. A twice transposed matrix is ​​equal to the original matrix:

2. When transposing square matrices, the elements located on the main diagonal do not change their positions, i.e. The main diagonal of a square matrix does not change when transposed.

Matrix multiplication

Matrix multiplication is a specific operation that forms the basis of matrix algebra. The rows and columns of matrices can be considered as row and column vectors of appropriate dimensions; in other words, any matrix can be interpreted as a collection of row vectors or column vectors.

Let two matrices be given: A- size T X P And IN- size p x k. We will consider the matrix A as a totality T row vectors A) dimensions P each, and the matrix IN - as a totality To column vectors b Jt containing each P coordinates each:


Matrix row vectors A and matrix column vectors IN are shown in the notation of these matrices (2.7). Matrix row length A equal to the height of the matrix column IN, and therefore the scalar product of these vectors makes sense.

Definition 3. Product of matrices A And IN is called a matrix C whose elements Su are equal to the scalar products of row vectors A ( matrices A into column vectors bj matrices IN:

Product of matrices A And IN- matrix C - has the size T X To, since the length l of row vectors and column vectors disappears when summing the products of the coordinates of these vectors in their scalar products, as shown in formulas (2.8). Thus, to calculate the elements of the first row of matrix C, it is necessary to sequentially obtain the scalar products of the first row of the matrix A to all matrix columns IN the second row of matrix C is obtained as the scalar product of the second row vector of the matrix A to all column vectors of the matrix IN, and so on. For the convenience of remembering the size of the product of matrices, you need to divide the products of the sizes of the factor matrices: - , then the remaining numbers in relation give the size of the product To

dsnia, t.s. the size of matrix C is equal to T X To.

The operation of matrix multiplication has a characteristic feature: the product of matrices A And IN makes sense if the number of columns in A equal to the number of lines in IN. Then if A and B - rectangular matrices, then the product IN And A will no longer make sense, since the scalar products that form the elements of the corresponding matrix must involve vectors with the same number of coordinates.

If matrices A And IN square, size l x l, makes sense as a product of matrices AB, and the product of matrices VA, and the size of these matrices is the same as that of the original factors. In this case, in the general case of matrix multiplication, the rule of permutation (commutativity) is not observed, i.e. AB * VA.

Let's look at examples of matrix multiplication.


Since the number of matrix columns A equal to the number of rows of the matrix IN, product of matrices AB has the meaning. Using formulas (2.8), we obtain a matrix of size 3x2 in the product:

Work VA does not make sense, since the number of matrix columns IN does not match the number of matrix rows A.

Here we find the matrix products AB And VA:

As can be seen from the results, the product matrix depends on the order of the matrices in the product. In both cases, the matrix products have the same size as the original factors: 2x2.


In this case the matrix IN is a column vector, i.e. a matrix with three rows and one column. In general, vectors are special cases of matrices: a row vector of length P is a matrix with one row and P columns, and the height column vector P- matrix with P rows and one column. The sizes of the given matrices are respectively 2 x 3 and 3 x I, so the product of these matrices is defined. We have

The product produces a matrix of size 2 x 1 or a column vector of height 2.


By sequentially multiplying matrices we find:


Properties of the product of matrices. Let A, B and C are matrices of appropriate sizes (so that matrix products can be determined), and a is a real number. Then the following properties of the product of matrices hold:

  • 1) (AB)C = A(BC);
  • 2) C A + B)C = AC + BC
  • 3) A (B+ C) = AB + AC;
  • 4) a (AB) = (aA)B = A(aB).

The concept of the identity matrix E was introduced in clause 2.1.1. It is easy to see that in matrix algebra it plays the role of unit, i.e. We can note two more properties associated with multiplication by this matrix on the left and on the right:

  • 5 )AE=A;
  • 6) EA = A.

In other words, the product of any matrix by the identity matrix, if it makes sense, does not change the original matrix.