Title :
Study on the fast judgment of abnormal value with Excel
Author :
Cheng Dao-wen ; Han Dong ; Wang Wen-yong ; Xiang Peng
Author_Institution :
Sch. of Basic Sci., Changchun Univ. of Technol., Changchun, China
Abstract :
This paper introduces the mathematical statistical method to judge the abnormal value. In that method, Excel is used to calculate the average and standard deviation of values. By using the computation result, the abnormal value can be determined by PauTa criterion or extreme-mean difference method. The result shows that it´s simple, fast and dependable for Excel to determine the abnormal value.
Keywords :
mathematics computing; statistical analysis; Excel; PauTa criterion; abnormal value judgment; average values; extreme-mean difference method; mathematical statistical method; standard deviation; Abnormal value; Excel; mathematical statistical method;
Conference_Titel :
Computer Science and Network Technology (ICCSNT), 2012 2nd International Conference on
Conference_Location :
Changchun
Print_ISBN :
978-1-4673-2963-7
DOI :
10.1109/ICCSNT.2012.6526020
