Application and Research of Microsoft Excel 2003 in Quality Control of Analytical Data of Geochemical Samples with Scale 1:50 000 and 1:200 000

详细信息   

• 责任者：Li Yong （No.3 Gold Geological Party of the Armed Police Force ; Harbin 150086 ; China）
• 刊名：Computing Techniques for Geophysical and Geochemical Exploration
• 出版年：2008
• 卷期：30(5)
• 关键词：计算机技术 ; computer techniques ; 插值方法 ; interpolation methods
• 页码：p.425-431
• 图表：6 illus., 4 tables, 15 refs.
• 分类号：1900
• issnNo：ISSN1001-1749
• isbnNo：CN51-1242/P

摘要

It has been reported that the Excel 2003 method can be used for quality control of analytical data of geochemical samples with the windows XP operating system. This suggests that one need only to key in the functions, i.e. SUM, POWER, STAT, LOGIC, and the automatic management will be completed for the quality control and error statistic of analytical data in data table. The statistical results of testing the national standard materials of GBW-07242～47 show that the method can rapidly prove whether the results of analysis quality of geochemical exploration samples with scale 1∶50 000 and 1∶200 000 is “ok” or “no”.