Excel在中学基础统计教学方面的应用

The Application of Excel in Probability and Statistics of Middle School Mathematics

随着信息技术的发展,对中学数学教育引入信息技术的应用尤其重要。在中学数学概率统计方面,概率的理解需要从随机的角度考虑,通过Excel产生大量随机数来代替重复进行随机试验得到的结果,使学生更容易接受频率与概率的联系。并且Excel能够计算事件发生的概率,比常规的计算更简单。另外Excel还可以对数据进行描述性统计分析,抽样以及回归拟合等,加上其强大的作图功能使Excel在中学数学概率统计方面有着极广泛的应用。

With the development of information technology, the introduction of secondary mathematics education is particularly important application of information technology.In the study of probability and statistics of middle school mathematics, the understanding of probability starts from the angle of random. Random numbers generated by Excellcan replace the results of repeated random experiences, making the relationship between the frequency and probability more easily to be understood. And Excellalso can calculate probability events, it is much simpler than the conventional calculation. Excellalso can carry out descriptive statistical analysis, sampling and regression fitting operation on data. Coupled with its practical mapping function, Excellhas wide application space in the field of mathematics statistics and probability of middle school.