The Calculation of the Three-Class Nested Variance of Geological Samples in Excel
详细信息
- 责任者：Zhang Shuang (Faculty of Earth Sciences ; China University of Geosciences ; Wuhan 430074 ; China) ; Li Fanglin
- 刊名：Geophysical and Geochemical Exploration
- 出版年：2010
- 卷期：34(3)
- 关键词：计算机程序 ; computer programs ; 方差分析 ; variance analysis
- 页码：p.403-406
- 图表：5 illus., 4 tables, 9 refs.
- 分类号：1900
- issnNo：ISSN1000-8918
- isbnNo：CN11-1906/P
摘要
Nested variance has been widely used in evaluating the quality of geological data. In fact, its computing process is complex, especially in the work with many samples such as the geochemical exploration and the manufacturing of the standard sample. As no software now can compute nested variance directly, people usually use the counter to count it or compute the F value in Excel so as to get the critical value through checking the table. Aimed at solving this problem, this paper has compiled the program in VBA language in Excel with the purpose of realizing the computation of three-class nested variance convincingly. At the same time, this paper discusses the utilization of the t-test in twin-swatch which collects samples two times but tests every sample only once.