土工指标统计程序.xls

《土工指标统计程序.xls》由会员分享，可在线阅读，更多相关《土工指标统计程序.xls（8页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、2ZK4-1粉质粘土30.319.32.730.8432ZK4-2粉质粘土28.819.62.730.7942ZK4-3粉质粘土36.418.72.740.9992ZK12-1粉质粘土27.519.902.700.7302ZK14-1粉质粘土30.519.102.720.8582ZK15-1粉质粘土30.019.302.700.819max36.419.902.740.999min27.518.702.700.730平均30.619.322.720.840标准差3.0640.4120.0170.090变异0.1000.0210.0060.107修正系数0.9170.9821.088标准值28.

2、119.00.915n66663ZK12-2淤泥质粉质粘土38.218.502.731.0393ZK15-2淤泥质粉质粘土40.218.002.701.1033ZK15-3淤泥质粉质粘土48.117.302.701.3113ZK19-1淤泥质粉质粘土49.117.42.731.3393ZK19-2淤泥质粉质粘土49.017.42.731.3383ZK19-3淤泥质粉质粘土47.417.42.731.313max49.118.502.731.339min38.217.302.701.039平均45.317.672.721.241标准差4.8330.4800.0150.133变异0.1070.02

3、70.0060.107修正系数1.0880.9781.089标准值49.317.31.351n666698.036.720.80.615.90.80.7690.7270.66999.038.121.90.4316.20.7220.6870.6510.600100.038.023.60.6714.40.9510.9170.8740.814100.031.220.40.6610.80.7430.7290.7140.69796.633.821.10.7412.70.8410.8240.7960.76298.934.222.60.6411.60.7820.7460.7020.651100.038.12

4、3.60.7416.20.9510.9170.8740.81496.631.220.40.4310.80.7220.6870.6510.60098.835.321.70.6213.60.8060.7790.7440.6991.2832.7331.2090.1052.2510.0820.0820.0790.0780.0130.0770.0560.1690.1660.1020.1050.1060.1111.1390.71666666666100.035.921.71.1614.20.9050.8420.7710.69398.434.221.81.4812.41.0540.9920.9140.827

5、99.034.122.52.2111.61.1181.0280.9280.81910037.8221.7215.81.1931.0760.9660.85610036.621.21.8115.41.1501.0280.9210.77899.037.621.31.616.31.1791.0790.9700.850100.037.822.52.2116.31.1931.0790.9700.85698.434.121.21.1611.60.9050.8420.7710.69399.436.021.81.6614.31.1001.0070.9120.8040.6881.6130.4760.3491.91

6、70.1080.0870.0730.0610.0070.0450.0220.2100.1340.0980.0870.0800.0761.1731.956666666660.424.3925.520.20.364.9829.021.20.434.6526.816.627.513.50.286.6425.513.60.444.1320.713.20.446.6429.021.20.284.1320.713.20.394.9625.816.40.0670.9902.8393.5780.1730.2000.1100.2181.1650.8110.9090.8200.454.0223.513.45566

7、0.712.877.514.50.782.7013.410.21.002.3112.69.81.102.1313.49.81.072.1913.29.61.092.1212.910.01.102.8713.414.50.712.127.59.60.962.3912.210.70.1700.3202.3071.8970.1780.1340.1900.1781.1470.8890.8430.8531.102.1210.39.16666abcder30.319.32.730.84398.036.728.819.62.730.79499.038.136.418.72.740.999100.038.02

8、7.519.902.700.730100.031.236.418.72.740.999100.038.030.519.102.720.85896.633.836.418.72.740.999100.038.027.519.902.700.730100.031.2max36.419.92.740.99910038.1min27.518.72.700.73096.64231.2平均31.719.22.730.86999.235.6标准值34.418.92.710.948100.133.5标准差4.0240.5210.0170.1171.2663.087变异0.1270.0270.0060.1350

9、.0130.087不利组合+-+-修正系数1.0860.9820.9961.0911.0090.941n888888SUBTOTALSUBTOTAL(function_numfunction_num,ref1ref1,ref2,.)Function_num 为 1 到 11（包含隐藏值）或 101 到 111（忽略隐藏值）之间的数字，指定使用何种函数在列表中进行分类汇总计算。Function_numFunction_numFunction_nuFunction_num m函函数数（包包含含隐隐藏藏值值）（忽忽略略隐隐藏藏值值）1101 AVERAGE2102 COUNT3103 COUNTA4

10、104 MAX5105 MIN6106 PRODUCT7107 STDEV8108 STDEVP9109 SUM10110 VAR11111 VARPtyuuiopz20.80.615.90.80.7690.7270.6690.4221.90.4316.20.7220.6870.6510.6000.3623.60.6714.40.9510.9170.8740.8140.4320.40.6610.80.7430.7290.7140.69723.60.6714.40.9510.9170.8740.8140.4321.10.7412.70.8410.8240.7960.7620.2823.60.67

11、14.40.9510.9170.8740.8140.4320.40.6610.80.7430.7290.7140.69723.60.7416.20.9510.9170.8740.8140.4320.40.4310.80.7220.6870.6510.60.2821.90.6413.70.80.80.80.70.420.90.7012.30.90.90.80.80.41.4650.0922.0830.1010.0960.0890.0800.0610.0670.1440.1520.1200.1180.1140.1090.156-+-+0.9551.0970.8971.0811.0801.0771.0741.12988888886Function_num 为 1 到 11（包含隐藏值）或 101 到 111（忽略隐藏值）之间的数字，指定使用何种函数在列表中进行分类汇总计算。cvw4.3925.520.24.9829.021.24.6526.816.627.513.54.6526.816.66.6425.513.64.6526.816.627.513.56.6372512921.24.3925.513.55.026.916.55.727.718.50.8271.1392.9810.1660.0420.181+1.1371.0291.122688