Excel统计函数在数据分析方面的应用技巧

Application of Excel Statistical Function in Data Analysis

Excel97/ 2 0 0 0是一较优秀的数据分析软件 ,利用其统计函数可很方便地进行常用的数据统计分析工作。在简要介绍了其常用统计函数的功能的基础上 ,首先介绍其在学生成绩分析和数据统计分析方面的应用实例 ,如计算平均分和各科平均成绩、查找最高和最低分、统计各分数段人数、计算总体方差和标准偏差、按成绩排序等 ;其次介绍其在实验数据的线性回归和相关性分析方面的应用实例 ,如求回归直线斜率、Y轴截距和求 X、Y两组数据的相关系数等 ;详细研究了其应用技巧。

Excel 97/2000 is a first-class data analyzing software.Using statistical function,we can conveniently process common work of data statistical analyzing.The paper briefly introduced the statistical function in common use.First of all,it introduced the actual applications in students' achievement analysis and data statistical analysis.For example,calculating average score,researching the highest and the lowest score,etc.Then,it introduced the actual applications in linear regression and relation analysis of experiment data.Such as calculating slop of line,correlation coefficient,and so on.To sum up,the methods and skill of statistical function in common use have been discussed in detail.