| 应用Excel函数数组功能进行数据自动统计 |
| |
| 引用本文： | 陈伟,陈东淼.应用Excel函数数组功能进行数据自动统计[J].东北电力学院学报,2005,25(6):92-94. |
| |
| 作者姓名： | 陈伟 陈东淼 |
| |
| 作者单位： | 东北电力学院媒体系,吉林,吉林,132012;东北电力学院自动化工程学院,吉林,吉林,132012 |
| |
| 摘 要： | Excel作为Office套装软件中的一种应用软件，具有丰富的函数，它能够利用函数实现一些简单的计算；但在遇到诸如学生成绩综合处理中的统计各分数段人数等特殊需求时，单纯依靠一个函数是无法直接实现的。本文主要介绍了如何利用Excel的函数数组功能去解决类似这样的复杂问题．从而为实现学生成绩综合处理自动化提供一个有效方法。
|
| 关 键 词： | Excel 函数数组 自动统计 |
| 文章编号： | 1005-2992（2005）06-0092-03 |
| 收稿时间： | 2005-08-31 |
| 修稿时间： | 2005-08-31 |
Using Applied Statistic for Student's Achievement with Microsoft Excel's Function |
| |
| CHEN Wei,CHEN Dong-miao.Using Applied Statistic for Student's Achievement with Microsoft Excel's Function[J].Journal of Northeast China Institute of Electric Power Engineering,2005,25(6):92-94. |
| |
| Authors: | CHEN Wei CHEN Dong-miao |
| |
| Affiliation: | 1. the Information-based Teaching Center of the North East Institute of Electric Power; 2. the College of Automation of the North East Institute of Electric Power,Jilin,Jilin 132012 |
| |
| Abstract: | Excel as a part of Microsoft Office package has abundant functions, which can be used for some primary calculation directly. However,for certain complex calculation such as treating student's achievement based on each band in the general management datasheet,it is not possible to fulfill the calculation with only one function directly. In this paper, the function array in Excel to fulfill conplex calculation is introduced and it will provide a effective metod for the system of student achievement. |
| |
| Keywords: | Excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
