DocumentCode
604406
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
fYear
2012
fDate
29-31 Dec. 2012
Firstpage
652
Lastpage
655
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Computer Science and Network Technology (ICCSNT), 2012 2nd International Conference on
Conference_Location
Changchun
Print_ISBN
978-1-4673-2963-7
Type
conf
DOI
10.1109/ICCSNT.2012.6526020
Filename
6526020
Link To Document