How Do You Solve Linear Equations With Excel?
Linear equations contain multiple variables and have to be simultaneous in order to be solved. Simultaneous linear equations can written in the general form as a1X + b1Y = c1 and a2X + b2Y = c2. A solution of such a system is a set of variables “X” and “Y” that simultaneously satisfy these equations. The letters “a1,” “a2,” “b1,” “b2,” “c1” and c2 abbreviate the numeric coefficients in equations. One method of solving such linear equations is to use Cramer’s rules. It involves calculations of determinants for three matrixes that are comprised from the equation coefficients. This method is easy to implement in Microsoft Excel using the program’s formulas feature. As an example, solve the following linear equations: -2X + 7Y = 15 and 3X + 12Y = -4. Open your user account in Windows XP/Vista and launch Microsoft Excel. Press “Ctrl-N” on the keyboard to create a new Excel worksheet. Click on the cell “A3” in the worksheet and press the key “=” on the keyboard. Type the following string “A1
