首页   按字顺浏览 期刊浏览 卷期浏览 Computer spreadsheets for numerical analysis
Computer spreadsheets for numerical analysis

 

作者: JeanB. Soper,   MartinP. Lee,  

 

期刊: International Journal of Mathematical Education in Science and Technology  (Taylor Available online 1994)
卷期: Volume 25, issue 2  

页码: 245-253

 

ISSN:0020-739X

 

年代: 1994

 

DOI:10.1080/0020739940250211

 

出版商: Taylor & Francis Group

 

数据来源: Taylor

 

摘要:

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.

 

点击下载:  PDF (444KB)



返 回