This preview shows pages 1–3. Sign up to view the full content.
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.
View Full Document 2
size of the resulting array. So, we select 3 rows and 3 columns and then we enter the formula
(=A+B) in the topleft 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.
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.
 Fall '09
 Clement

Click to edit the document details