整群抽样估计.xlsVIP

Sheet3 Sheet2 扩展的整群抽样估计 习题5-15计算结果 例5-20计算结果 均值估计程序 整群抽样区间估计 R= r = N = M= 样本群号 群平均数 全样本平均数 群间方差 群间标准差 抽样平均误差 置信水平 z 区间估计下限 区间估计上限 群成数 变质个数 % 整群抽样区间估计 R= r = N = M= 抽样平均误差 置信水平 z R= N = M= 离差平方 200.00 19.00 1.00 20.00 800.00 100.00 1.00 1.00 20.00 .20 5.93E-03 .00 .00 2.00 .12 7.84E-03 2.00 .09 .50 1.00 2.00 17.00 .17 2.21E-03 1.00 3.00 32.00 .32 .04 .02 .50 1.00 .50 1.00 4.00 24.00 .24 .01 .95 100.00 95.00 1.00 5.00 23.00 .23 .01 1.96 .98 1.00 2.00 1.00 6.00 18.00 .18 3.25E-03 1.00 7.00 16.00 .16 1.37E-03 8.62 100.00 1.00 8.00 12.00 .12 9.00E-06 15.98 100.00 1.00 9.00 3.00 .03 8.65E-03 1.00 10.00 9.00 .09 1.09E-03 1.00 11.00 6.00 .06 3.97E-03 1.00 12.00 2.00 .02 .01 1.00 13.00 6.00 .06 3.97E-03 1.00 14.00 12.00 .12 9.00E-06 1.00 15.00 20.00 .20 5.93E-03 1.00 16.00 20.00 .20 5.93E-03 .00 17.00 .00 .00 .00 1.00 18.00 1.00 .01 .01 1.00 19.00 2.00 .02 .01 1.00 20.00 3.00 .03 8.65E-03 .00 21.00 .00 .00 .00 .00 22.00 .00 .00 .00 .00 23.00 .00 .00 .00 .00 24.00 .00 .00 .00 .00 25.00 .00 .00 .00 .00 26.00 .00 .00 .00 .00 27.00 .00 .00 .00 .00 28.00 .00 .00 .00 .00 29.00 .00 .00 .00 .00 30.00 .00 .00 .00 .00 31.00 .00 .00 .00 .00 32.00 .00 .00 .00 .00 33.00 .00 .00 .00 .00 34.00 .00 .00 .00 .00 35.00 .00 .00 .00 .00 36.00 .00 .00 .00 .00 37.00 .00 .00 .00 .00 38.00 .00 .00 .00 .00 39.00 .00 .00 .00 .00 40.00 .00 .00 .00 .00 41.00 .00 .00 .00 .00 42.00 .00 .00 .00 .00 43.00 .00 .00 .00 .00 44.00 .00 .00 .00 .00 45.00 .00 .00 .00 .00 46.00 .00 .00 .00 .00 47.00 .00 .00 .00 .00 48.00 .00 .00 .00 .00 49.00 .00 .00 .00 .00 50.00 .00 .00 .00 200.00 20.00 800.00 100.00 1.00 20.00 .20 .12 8.63E-03 2.00 .09 2.00 17.00 .17 3.00 32.00 .32 .02 .50 1.00 .50 4.00 24.00 .24 .95 100.00 95.00 5.00 23.00 .23 1.96 .98 1.00 2.00 6.00 18.00 .18 7.00 16.00 .16 8.44 100.00 8.00 12.00 .12 16.16 100.00 9.00 3.00 .03 10.00 9.00 .09 11.00 6.00 .06 12.00 2.00 .02 13.00 6.00 .06 14.00 12.00 .12 15.00 20.00 .20 16.00 20.00 .20 17.00 .00 .00 18.00 1.00 .01 19.00