Matrices and Iterative Procedures

In this section we review the key characteristics of matrices and describe how to perform various matrix operations in Excel. We also describe some related topics, such as determinants and solution of simultaneous linear equations, as well as iterative procedures, such as Newton’s method and Iterative Proportional Fitting Procedure (IPFP). Finally we show how to use Excel’s built-in iterative methods Goal Seek and Solver.


Leave a Reply

Your email address will not be published. Required fields are marked *