首页 | 本学科首页   官方微博 | 高级检索  
     

用Excel来演示解线性方程组的过程
引用本文:黄明新. 用Excel来演示解线性方程组的过程[J]. 重庆工商大学学报(自然科学版), 2004, 21(5): 513-515
作者姓名:黄明新
作者单位:重庆工商大学,理学院,重庆,400067
摘    要:探讨了Excel的数值计算功能,阐述了用这些功能在电子表格上直接进行初等变换的计算过程。并用Microsoft Excel的公式复制功能演示迭代法解线性方程组的迭代结果,最后指出了使用Microsoft Excel演示解线性方程组时应注意的问题。

关 键 词:线性方程组 行初等变换 迭代法 数值计算 公式 演示 计算过程 电子表格
文章编号:1672-058X(2004)05-0513-03

Demonstrating the processes of solving the set of linear equations by Microsoft Excel
HUANG Ming-xin. Demonstrating the processes of solving the set of linear equations by Microsoft Excel[J]. Journal of Chongqing Technology and Business University:Natural Science Edition, 2004, 21(5): 513-515
Authors:HUANG Ming-xin
Abstract:The teaching of mathematics class emphasizes processes of proving and solving problems. In the teaching, the teacher must demonstrate clearly the process to students step by step. In the teaching of elementary transform and solving set of linear equations in linear algebra, due to more data and steps, mistakes occur easily, It follows a bad effect on understanding of mathematics senses. The Microsoft Excel has higher numerical functions and automatic re-calculating function, It directly computes vectors and matrices in the forms, and may demonstrate the processes of elementary transform and elimination of set of linear equations by arithmetical array functions of Microsoft Excel and, perform iteration of set of linear equations by formula-coping and auto-computing functions of Microsoft Excel.
Keywords:Microsoft Excel  set of linear equations  elimination  iteration  demonstrating processes
本文献已被 CNKI 维普 万方数据 等数据库收录!
点击此处可从《重庆工商大学学报(自然科学版)》浏览原始摘要信息
点击此处可从《重庆工商大学学报(自然科学版)》下载全文
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号