EXCEL在概率论与数理统计中的应用  

The application of Excel in Teaching of Probability and Statistics

作　　者：林彤[1] 

机构地区：[1]东北电力大学理学院,吉林吉林132012

出　　处：《东北电力大学学报》2013年第6期52-55,共4页Journal of Northeast Electric Power University

摘　　要：通过教学实践探讨在概率论与数理统计教学中融入Excel应用的教学改革,通过对常见分布、假设检验及回归分析等方面详细介绍了Excel在教学过程中的具体应用。将Excel应用于课堂教学,能够激发学生的学习热情,提高教学效果。We discussed the advantages of melting excellfunction in teaching of probability and statistics in Universities though the teaching practice. We introduced the detailed excellfunctions in the calculations of common distributions,hypothesis test and the regression analysis. The excellapplying in class will improve en-thusiasm and motivation of students greatly in their study and strengthen the teaching effect.

关 键 词：概率论与数理统计 EXCEL 二项分布 假设检验 回归分析 

分 类 号：O21[理学—概率论与数理统计]