Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 size of the resulting array. So, we select 3 rows and 3 columns and then we enter the formula (=A+B) in the top-left cell of the selected cell range. Figure 8.3 Highlighting the size of the resulting array Notice that when you use the named arrays in the formula, Excel highlights the arrays. This helps you check that the correct arrays are being used in the formula. To obtain the result, DO NOT PRESS [ENTER]. To tell Excel that we are using array math, we should use a special character sequence. Press and Hold [Ctrl]+[Shift] and then press then [Enter] key. The result will be displayed as below once you press [Ctrl]+[Shift]+[Enter] Figure 8.4 Displaying the result Alternately, this can also be done without using the named arrays by simply using the cell ranges as shown in Figure 8.5.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/14/2011 for the course CE 3010 taught by Professor Clement during the Fall '09 term at Auburn University.

Page1 / 8


This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online