1 LAB ASSIGNMENT -6 MATRIX OPERATIONS IN EXCEL 8.1 ARRAYS IN EXCEL: Excel uses arrays to store a collection of variables. These arrays can be used to perform matrix operations. To declare a bunch of numbers as an array, you select the numbers that make up the matrix and type the name of the array in the “Name Box” as shown in the Figure 8.1. Figure 8.1 Naming arrays Alternately, we can name an array by selecting the numbers and clicking on the “Formulas” ribbon and choosing “Define name”. Using named arrays ensures that we can use the names instead of the cell range in array formulas. It is not necessary to name the arrays for matrix operations in Excel but this helps in keeping the spreadsheet organized and easy to understand. 8.2 BASIC MATRIX OPERATIONS: 8.2.1 ADDITION:Before performing the addition, you should ensure that the matrices to be added are of the same size. Name the two matrices as arrays A and B using the method described above. Figure 8.2 Matrix addition using array math in excel In the above example, A and B are both square matrices of size 3x3. The resulting matrix (A+B) would also be of the order 3x3. When using array math in Excel, we should always indicate the
This preview has intentionally blurred sections.
Sign up to view the full version.