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 threeclass 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.
张爽, 李方林, 鲍征宇. Excel下地质数据三层套合方差分析的实现[J]. 物探与化探, 2010, 34(3): 403-406.
ZHANG Shuang, LI Fang-Lin, BAO Zheng-Yu. THE CALCULATION OF THE THREECLASS NESTED VARIANCE OF GEOLOGICAL SAMPLES IN EXCEL. Geophysical and Geochemical Exploration, 2010, 34(3): 403-406.