用Excel的数据分析工具分析试卷  

Analyze Examination Papers with Data Analysis Tool of Microsoft Excel

作　　者：吕洪升[1] 

机构地区：[1]巢湖学院,安徽巢湖238000

出　　处：《巢湖学院学报》2004年第3期33-36,共4页Journal of Chaohu University

摘　　要：本文用Microsoft Excel提供的函数功能和统计分析工具对某科考试的总体试卷进行分析,既方便快捷,又易于操作,且可得到许多有用数据和相关信息,便于用数理统计理论推断考试总体情况,可供教师分析试卷时推广使用。In this paper the author gives a general analysis for examination papers of a certain subject with the method of function and statistics analysis from Microsoft Excel. This is not only quick and easy to be applied but also convenient to be used to obtain a lot of data and information. And the theory of mathematical statistics can be easily used to infer the general aspects of any examination. This method can be popularized for teachers in analyzing any kinds of examination papers.

关 键 词：数据分析 直方图 样本方差 标准偏差 置信度 众数 中位数 

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