CAJ | 학술논문

Excel是一个数据处理功能很强的软件，其大量实用的函数库可以为各项统计工作提供全面的支持。本文结合笔者自身工作实践，针对水质资料整编工作中最大值、最小值、平均值和超标率四项特征值统计，提出了运用Excel函数实现数据批量快速处理的解决方案，在消除人为错误隐患的同时极大提高了整编工作效率，并成功应用于太湖流域2009~2012年水质资料整编工作中。
Excel시일개수거처리공능흔강적연건，기대량실용적함수고가이위각항통계공작제공전면적지지。본문결합필자자신공작실천，침대수질자료정편공작중최대치、최소치、평균치화초표솔사항특정치통계，제출료운용Excel함수실현수거비량쾌속처리적해결방안，재소제인위착오은환적동시겁대제고료정편공작효솔，병성공응용우태호류역2009~2012년수질자료정편공작중。
Excel is a powerful software for data processing,it has a large number of practical function library which can provide comprehensive support for statistical work. In this paper, combined with the author's own work practice, the application of Excel function for data batch processing is proposed for statistics of maximum, minimum, average, and over standard rate in the water quality data compilation, which not only eliminates the artificial mistakes and hidden trouble, but also greatly improves the compilation efficiency. It has been successfully applied in the water quality data compilation work of Taihu basin in 2009-2011.