Solve 3 linear equations in 3 unknowns on a spreadsheet
Quickly scroll down to the bottom of the image.
The program used is Excel. The steps are:
- Enter the matrix of coefficients and the column of constants.
- Select a 3-by-3 region to hold the inverse of the coefficient matrix.
Enter =MINVERSE(a1:c3) and
- press CTRL-SHIFT-ENTER to enter the formula into all
cells of the region.
- Select a 3-by-1 column to hold the answer, enter
=MMULT(a5:c7,e5:e7) and
- press CTRL-SHIFT-ENTER to enter the formula into all
cells in the column.
- If you want the answer in fractional form, you can select
the cells where you want fractions, select Format-Cells,
and give all the cells the format ????/????.
To see the procedure again, reload this page
This page is maintained by: Robert F. Rossa who can be reached at
rossa@csm.astate.edu
Last revised on: 11/20/96