Excel TRANSPOSE function

In an Excel spreadsheet, the [TRANSPOSE function can be applied to an array of data. For this, we need to become familiar with the two most important rules to perform matrix operations in Excel ... 

Excel provides functions for the manipulation of arrays or matrices TRANSPOSE(array) returns the transpose of an array, MDETERM(array) returns the matrix determinant of an array, MINVERSE(array) returns the matrix inverse of an array, MMULT(arrayl, array2) returns the matrix product of two arrays and SUMPRODUCT(arrayI, array2,. ..) returns the sum of the products of corresponding array elements. These functions are discussed more fully in Chapter 9. 

This exercise introduces two new features of the EXCEL software the matrix multiplication and transpose macros MMULT() and the TRANSPOSE(). These are best activated using the =/ icon on the TOOLBAR and the option to drag out the array data to be multiplied, visible in the function window. You select an equal area of blank cells on the spreadsheet and then activate the MMULT() or TRANSPOSEO macros. Note too that after selecting the particular area for each array, the sequence to enter these cell references requires CTL/SHIFT/ENTER. Otherwise, only one entry will appear in the top-left hand cell of the chosen active cells for the operation. 

Among the many choices are Transpose, Inverse, Determinant, System AX = B, Multiplication, and Pseudoinverse. The Inverse and Multiplication choices can be used to solve Ax = b instead of using the built-in Excel functions. The System AX = B selection solves a linear system directly and even allows for the right-hand side to be a matrix and, thus, a matrix of solutions. 

---

See also in sourсe #XX -- [ , ]

---