14.7 Matrix Computation with Excel 445
The formulation of many engineering problems leads to a system of algebraic equations.
As you will learn later in your math and engineering classes, there are a number of ways that you
can use Excel to solve a set of linear equations. Using Example 14.9, we will show how you can
use Excel to obtain a solution to a simultaneous set of linear equations.Example 14.9 Consider the following three linear equations with three unknowns:x 1 ,x 2 , andx 3. Our intent
here is to show you how to use Excel to solve a set of linear equations.The solution to this problem is discussed in detail in Chapter 18 and is given by:x 1 2,
x 2 5, andx 3 4. The solution easily can be verified by substituting the results (the values of
x 1 ,x 2 , andx 3 ) back into the three linear equations.Q.E.D.
Now the Excel solution. Refer to the Excel sheets shown in the accompanying figures when
following the steps.- In the cells shown, type the appropriate characters and values. Use the Format Cellsand
Fontoption to create the bold and subscript variables.
5122 5 3142 17
3122 2152 4142 32
2122 5 4 13
5 x 1 x 2 3 x 3 17
3 x 1 2 x 2 4 x 3 32
2 x 1 x 2 x 3 13
Copyright 2010 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀圀圀圀⸀夀䄀娀䐀䄀一倀刀䔀匀匀⸀䌀伀䴀