This paper illustrates how electronic spreadsheet programs, such as Lotus 1-2-3 and Microsoft Excel, can be used for numerical analysis. It begins by considering the nature of spreadsheets with particular reference to their precision and accuracy. It continues with an extended example taken from matrix manipulation which uses both the Jacobi and Gauss-Seidel iterative methods for solving sets of simultaneous equations. The spreadsheet approach allows users to compare the details of how the two methods work. The paper concludes with a restatement of the advantages of spreadsheets for numerical analysis. © 1994 Taylor & Francis Ltd.
CITATION STYLE
Soper, J. B., & Lee, M. P. (1994). Computer spreadsheets for numerical analysis. International Journal of Mathematical Education in Science and Technology, 25(2), 245–253. https://doi.org/10.1080/0020739940250211
Mendeley helps you to discover research relevant for your work.