Wednesday, November 18, 2009

MATRICES

LINK: Back to Contents
Arranging numbers in a Rectangular Form
is an integral part of a spreadsheet.
Mathematics has been using this style
before computers existed. The MATRIX
is a RECTANGULAR ARRAY OF NUMBERS.

The DIMENSION of a Matrix has two
numbers the first reflects the
number of rows and the second number
represents the number of columns.
Here is a matrix with
three rows and two columns:


Here is a link to a great Matrix Site:


INVERSE MATRICES
(only exist for a SQUARE MATRIX)
are used to solve Simultaneous Equations

A=[1 2 3; 4 1 2; 5 4 2]

A =
1 2 3
4 1 2
5 4 2

inv(A)=
-6/31 8/31 1/31
2/31 -13/31 10/31
11/31 6/31 -7/31

No comments:

Post a Comment