混凝土试件平均值、标准差、离差系数的计算

1、序序号号计计算算项项目目C15C15C20C20C25C251右侧数据19.425.429.3219.425.2319.325.9418.925.1518.925.3619.2789101112131415161718192021222324统计个数651最大值19.4025.9029.30最小值18.9025.1029.30平均值（Rn）19.1825.3829.30标准差（Sn）0.230.31#DIV/0!变异（离差）系数（Cv）0.010.01#DIV/0!验算（Rn-0.7*Sn）R标19.0225.16#DIV/0!验算（Rn-1.6*Sn）0.83R标 （R标20）18.8112

2、.4524.8816.60#DIV/0!20.75验算（Rn-1.6*Sn）0.80R标 （R标20）18.8112.0024.88#DIV/0!保证率系数（t）-25.111.22#DIV/0!-25.111.22#DIV/0!保证率（8085）0.841.048590（1.041.28）9095（1.281.63）-286.9889.14#DIV/0!结论优良合格优良C30C30C40C40M7.5M1035.69.012.235.99.513.012.6202335.900.009.5013.0035.600.009.0012.2035.75#DIV/0!9.2512.600.21#DI

3、V/0!0.350.400.015.305.6635.60#DIV/0!9.0012.3235.4124.90#DIV/0!33.208.6833.2011.9633.2035.41#DIV/0!32.008.6832.0011.9632.0074.25#DIV/0!-0.22-0.1074.25#DIV/0!-30.41-18.50序序号号计计算算项项目目C15C15C20C20C25C251右侧数据18.622.0219.322.7318.122.941924.1518.723.8618.8718.8818.8918.41018.311191219.31318.41418.51518.51

4、618.917191819.21918.72018.72119.32219.62319.12419.2统计个数2450最大值19.6024.100.00最小值18.1022.000.00平均值（Rn）18.8423.10#DIV/0!标准差（Sn）0.370.85#DIV/0!变异（离差）系数（Cv）0.020.04#DIV/0!验算（Rn-0.7*Sn）R标18.5822.50#DIV/0!验算（Rn-1.6*Sn）0.83R标 （R标20）18.2512.4521.7416.60#DIV/0!20.75验算（Rn-1.6*Sn）0.80R标 （R标20）18.2512.0021.74#DI

5、V/0!保证率系数（t）-16.51-2.23#DIV/0!-16.51-2.23#DIV/0!保证率（8085）0.841.048590（1.041.28）9095（1.281.63）-164.2139.84#DIV/0!结论优良合格优良C30C30C40C4035.333.733.53035.300.0033.500.0034.17#DIV/0!0.99#DIV/0!0.0333.48#DIV/0!32.5924.90#DIV/0!33.2032.59#DIV/0!32.0014.36#DIV/0!14.36#DIV/0!序序号号计计算算项项目目灌灌浆浆平平台台C20C20基基础础换换填填

6、C10C10马马道道、沟沟底底C15C151右侧数据20.7223.2324.8422.1523.0621.2720.8821.1925.01020.31121.61220.21320.91421.8151617181920212223242526272829303132统计个数14.000.000.00最大值25.000.000.00最小值20.2017.000.009.500.0012.75平均值（Rn）21.91#DIV/0!11.50#DIV/0!标准差（Sn）1.55#DIV/0!#DIV/0!变异系数（Cv）0.07#DIV/0!#DIV/0!计算统计修正系数的过程3.740.00

7、0.00196.000.000.000.46#DIV/0!#DIV/0!0.02#DIV/0!#DIV/0!0.03#DIV/0!#DIV/0!统计修正系数0.97#DIV/0!#DIV/0!标准值21.16#DIV/0!#DIV/0!验算（Rn-0.7*Sn）R标20.8220.00#DIV/0!#DIV/0!验算（Rn-1.6*Sn）0.83R标 （R标20）19.4216.60#DIV/0!#DIV/0!验算（Rn-1.6*Sn）0.80R标 （R标20）19.42#DIV/0!8.00#DIV/0!12.00保证率系数（t）1.23#DIV/0!#DIV/0!1.23#DIV/0!#D

8、IV/0!护护坡坡方方格格C15C15坝坝顶顶C25C2515.728.116.428.316.426.715.727.126.026.026.525.626.926.226.727.026.526.826.84.0015.0016.4028.3015.7017.0025.6016.0526.750.400.720.030.032.003.8716.00225.000.850.440.290.020.030.010.970.9915.5926.4115.7726.2415.4016.6025.5915.4025.59-9.779.33-9.779.33序序号号计计算算项项目目灌灌浆浆平平台台C

9、20C20基基础础换换填填C10C10马马道道、沟沟底底C15C151右侧数据20.7223.2324.8422.1523.0621.2720.8821.1925.01020.311121314151617181920212223242526272829303132统计个数10.000.000.00最大值25.000.000.00最小值20.3017.000.009.500.0012.75平均值（Rn）22.22#DIV/0!11.50#DIV/0!标准差（Sn）1.71#DIV/0!#DIV/0!变异系数（Cv）0.08#DIV/0!#DIV/0!计算统计修正系数的过程3.160.000.0

10、0100.000.000.000.54#DIV/0!#DIV/0!0.05#DIV/0!#DIV/0!0.05#DIV/0!#DIV/0!统计修正系数0.95#DIV/0!#DIV/0!标准值21.22#DIV/0!#DIV/0!验算（Rn-0.7*Sn）R标21.0220.00#DIV/0!#DIV/0!验算（Rn-1.6*Sn）0.83R标 （R标20）19.4916.60#DIV/0!#DIV/0!验算（Rn-1.6*Sn）0.80R标 （R标20）19.49#DIV/0!8.00#DIV/0!12.00保证率系数（t）1.30#DIV/0!#DIV/0!1.30#DIV/0!#DIV/

11、0!护护坡坡方方格格C15C15预预制制块块C20C20坝坝顶顶C25C2515.721.628.116.420.228.316.420.926.715.721.827.126.026.026.525.626.926.226.727.026.526.826.84.004.0015.0016.4021.8028.3015.7017.0020.2025.6016.0521.1326.750.400.730.720.030.030.032.002.003.8716.0016.00225.000.850.850.440.290.290.020.030.040.010.970.960.9915.5920

12、.2926.4115.7720.6226.2415.4016.6019.9625.5915.4019.9625.59-9.771.559.33-9.771.559.33序序号号计计算算项项目目C15C15C30C30C20C201右侧数据19.03321.9218.235.422.9318.534.321.1419.533.822.5519.634.821.7618.933.023.9718.133.423.6817.434.621.9918.732.623.219.533.624.31934.625.11018.435.422.81118.522.9121925.01318.723.6141

13、91517.316201717.61819.719192017.82119.32219.22318.12418.42518.62619.02718.62817.32918.73019.63118.618.919.219.717.818.219.318.418.718.519.317.818.418.919.318.418.919.718.518.619.619.319.717.418.919.618.717.918.419.919.719.619.719.618.718.919.618.719.319.732统计个数721215最大值20.0035.4025.10最小值17.3032.6021

14、.10平均值（Rn）18.8434.0423.09标准差（Sn）0.680.951.18变异（离差）系数（Cv）0.040.030.05验算（Rn-0.7*Sn）R标18.3633.3822.27验算（Rn-1.6*Sn）0.83R标 （R标20）17.7532.5321.20验算（Rn-1.6*Sn）0.80R标 （R标20）17.7532.5321.20保证率系数（t）5.6514.822.625.6514.822.62保证率（8085）0.841.04200.26429.61124.418590（1.041.28）9095（1.281.63）152.43右侧数据C20C2016.624.

15、912序序号号计计算算项项目目0-500-50箱箱涵涵C25C25唐唐家家冲冲隧隧洞洞C20C201#1#涵涵洞洞C20C201#1#涵涵洞洞C10C101右侧数据30.223.122.91217.3228.317.722.21317.7327.319.225.117.6428.423.622.216.7529.321.224.317627.419.625.616.4729.620.324.518.1833.623.216.4933.827.417.21032.326.818.11133.124.516.91227.523.117.51333.8171433.417.2151617181920

16、21222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475统计个数14712214最大值33.8023.6027.4013.0018.10最小值27.3017.7022.2012.0016.40平均值（Rn）30.5720.6724.3212.5017.22均方差（Sn）2.632.121.700.710.54离差系数（Cv）0.090.100.070.060.03计算统计修正系数的过程3.742.653.461.413.74196.

17、0049.00144.004.00196.000.460.640.491.200.460.020.100.031.170.020.040.080.040.130.02统计修正系数0.960.920.960.870.98标准值29.3119.1023.4310.8216.96验算（Rn-0.7*Sn）R标28.7320.0019.1923.1312.0116.84验算（Rn-1.6*Sn）0.83R标 （R标20）26.3616.6017.2816.6021.6011.3716.35验算（Rn-1.6*Sn）0.80R标 （R标20）26.3617.2821.6011.3716.35保证率系数（

18、t）2.122.672.54-10.614.104.010.322.54-10.61-5.12保证率（8085）0.841.048590（1.041.28）合格9095（1.281.63）101.9471.71109.8871.71108.04-79.81130.23结论合格合格合格合格埋埋石石C10C10垫垫层层( (回回填填)C15)C1525.823.127.217.726.519.228.123.627.621.22619.627.420.326.728.728.428.127.626.327.927.426.126.326.428.227.126.931.529.326.825.92

19、6.827.328.427.728.226.627.527.529.229.428.228.525.827.427.426.529.61#1#涵涵洞洞C10C104231.5025.8027.401.160.046.481764.000.260.000.010.9927.0926.5825.5425.542.076.38101.23合格序序号号计计算算项项目目进进口口段段C20C20闸闸室室段段C25C25泄泄水水段段C20C20闸闸室室、泄泄水水段段C30C301右侧数据20.919.418.233.4221.821.725.329.8321.322.819.135.9421.622.621

20、.338.7521.820.021.728.1617.020.718.731.2720.321.222.236.7822.822.621.332.2920.321.622.931.21021.921.220.030.11120.821.919.11221.421.822.91322.521.319.31423.120.221.81520.821.621.61620.922.71722.421.61818.621.61918.720.42021.120.42119.522.12220.920.52321.625.52421.521.92519.321.12620.826.22723.828293

21、03132统计个数15262710最大值23.1022.8026.2038.70最小值17.0018.6018.2028.10平均值（Rn）21.2221.0021.6032.73标准差（Sn）1.441.172.013.40变异系数（Cv）0.070.060.090.10计算统计修正系数的过程3.875.105.203.16225.00676.00729.00100.000.440.330.330.540.020.010.010.050.030.020.030.06统计修正系数0.970.980.970.94标准值20.5620.6020.9330.74验算（Rn-0.7*Sn）R标20.2

22、120.0020.1820.1920.0030.35验算（Rn-1.6*Sn）0.83R标 （R标20）18.9216.6019.1216.6018.3816.6027.30验算（Rn-1.6*Sn）0.80R标 （R标20）18.9219.1218.3827.30保证率系数（t）0.850.850.803.750.850.850.803.75保证率（8085）0.841.048590（1.041.28）9095（1.281.63）结论合格合格合格消消力力段段( (含含放放空空尾尾)C20)C20消消力力段段C25C25箱箱涵涵段段C25C25箱箱涵涵段段C20C20明明渠渠段段C20C202

23、0.434.225.721.921.434.230.926.22422.330.932.825.321.122.732.825.42521.231.625.72621.223.626.725.322.022.927.923.920.628.829.925.620.625.128.220.332.627.420.526.926.620.821.425.820.833.725.829.924.520.431.71581231534.2034.2028.2024.0031.7020.4025.4023.9021.1015.0027.6829.1925.9222.3322.435.023.291.121.503.000.180.110.040.070.133.872.833.461.733.87225.0064.00144.009.00225.000.440.600.490.980.440.020.070.030.520.020.080.080.020.100.060.920.920.980.900.9425.3