Computer spreadsheets for numerical analysis
Authors:
Jean B. Soper a;
Martin P. Lee b
| Affiliations: | a Department of Economics, University of Leicester, England |
| b Computing Information Systems Management Group, Royal Military College of Science, Cranfield University, Shrivenham, England |
DOI:
10.1080/0020739940250211
Publication Frequency:
8 issues per year
Published in:
International Journal of Mathematical Education in Science and Technology,
Volume
25,
Issue
2
April
1994
, pages 245
- 253
Subjects:
Educational Research;
Engineering Education;
Mathematics;
Mathematics & Numeracy;
Mathematics Education;
Science Education;
Formats available:
PDF
(English)
View Article:
View Article (PDF)
Abstract
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.
|
| view references (1) : view citations |

Download Citation


CiteULike
Del.icio.us
BibSonomy
Connotea