平均值转标准值.xls

《平均值转标准值.xls》由会员分享，可在线阅读，更多相关《平均值转标准值.xls（32页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、1层统计频数 n=6统计频数k1=1.704/N0.50.695655087k2=4.678/N20.129944444K=0.825599531变异系数=0.086变异系数=1-k0.92899844平均值m=16.2平均值标准值k=m 15.04977473标准值2层统计频数 n=15统计频数k1=1.704/N0.50.439970908k2=4.678/N20.020791111K=0.460762019变异系数=0.095变异系数=1-k0.956227608平均值m=10.3平均值标准值k=m 9.849144364标准值31层统计频数 n=7统计频数k1=1.704/N0.50.

2、644051462k2=4.678/N20.095469388K=0.73952085变异系数=0.053变异系数=1-k0.960805395平均值m=19.3平均值标准值k=m 18.54354412标准值n=6k1=1.704/N0.50.695655087k2=4.678/N2 0.129944444K=0.825599531=0.119=1-k0.901753656m=13.5k=m 12.17367435n=15k1=1.704/N0.50.439970908k2=4.678/N2 0.020791111K=0.460762019=0.187=1-k0.913837502m=7.9

3、k=m 7.219316269n=7k1=1.704/N0.50.644051462k2=4.678/N2 0.095469388K=0.73952085=0.051=1-k0.962284437m=11.1k=m 10.68135725统计频数 n=39统计频数n=k1=1.704/N0.50.272858374k1=1.704/N0.5k2=4.678/N20.003075608k2=4.678/N2K=0.275933982K=变异系数=0.32变异系数=1-k0.911701126=1-k平均值m=13平均值m=标准值k=m11.85211463标准值k=m统计频数 n=8统计频数n=

4、k1=1.704/N0.50.602454978k1=1.704/N0.5k2=4.678/N20.07309375k2=4.678/N2K=0.675548728K=变异系数=0.2变异系数=1-k0.864890254=1-k平均值m=23平均值m=标准值k=m19.89247585标准值k=m统计频数 n=41统计频数n=k1=1.704/N0.50.26612009k1=1.704/N0.5k2=4.678/N20.002782867k2=4.678/N2K=0.268902958K=变异系数=0.31变异系数=1-k0.916640083=1-k平均值m=17平均值m=标准值k=m1

5、5.58288141标准值k=m统计频数 n=8统计频数n=k1=1.704/N0.50.602454978k1=1.704/N0.5k2=4.678/N20.07309375k2=4.678/N2K=0.675548728K=变异系数=0.59变异系数=1-k0.601426251=1-k平均值m=8平均值m=标准值k=m4.811410006标准值k=m390.2728583740.0030756080.2759339820.380.89514508710.59.39902341180.6024549780.073093750.6755487280.360.75680245818.514.

6、00084547410.266120090.0027828670.2689029580.610.83596919686.68775356780.6024549780.073093750.6755487280.330.7770689232.525.2547399C12层统计频数 n=28k1=1.704/N0.50.322025731k2=4.678/N20.005966837K=0.327992568变异系数=0.19=1-k0.937681412平均值m=33.5标准值k=m 31.4123273113层统计频数 n=8k1=1.704/N0.50.602454978k2=4.678/N2

7、0.07309375K=0.675548728变异系数=0.12=1-k0.918934153平均值m=15.8标准值k=m 14.5191596121层统计频数 n=38k1=1.704/N0.50.276425302k2=4.678/N20.003239612K=0.279664914变异系数=0.15=1-k0.958050263平均值m=14.8标准值k=m 14.1791438923层统计频数 n=10k1=1.704/N0.50.538852113k2=4.678/N20.04678K=0.585632113变异系数=0.331=1-k0.806155771平均值m=10.8标准值

8、k=m 8.70648232123a层统计频数 n=6k1=1.704/N0.50.695655087k2=4.678/N20.129944444K=0.825599531变异系数=0.48=1-k0.603712225平均值m=20.8标准值k=m 12.5572142824层统计频数 n=10k1=1.704/N0.50.538852113k2=4.678/N20.04678K=0.585632113变异系数=0.22=1-k0.871160935平均值m=14.5标准值k=m 12.6318335625层统计频数 n=6k1=1.704/N0.50.695655087k2=4.678/N

9、20.129944444K=0.825599531变异系数=0.54=1-k0.554176253平均值m=11.3标准值k=m 6.26219165926层统计频数 n=25k1=1.704/N0.50.3408k2=4.678/N20.0074848K=0.3482848变异系数=0.13=1-k0.954722976平均值m=17.8标准值k=m 16.9940689731层统计频数 n=6k1=1.704/N0.50.695655087k2=4.678/N20.129944444K=0.825599531变异系数=0.28=1-k0.768832131平均值m=6.8标准值k=m 5.

10、228058492统计频数 n=28k1=1.704/N0.5 0.322025731k2=4.678/N2 0.005966837K=0.327992568变异系数=0.11=1-k0.963920818平均值 m=15.2标准值 k=m14.65159643统计频数 n=8k1=1.704/N0.5 0.602454978k2=4.678/N20.07309375K=0.675548728变异系数=0.13=1-k0.912178665平均值 m=9.4标准值 k=m8.574479455统计频数 n=38k1=1.704/N0.5 0.276425302k2=4.678/N2 0.003

11、239612K=0.279664914变异系数=0.12=1-k0.96644021平均值 m=8.7标准值 k=m8.40802983统计频数 n=9k1=1.704/N0.50.568k2=4.678/N2 0.057753086K=0.625753086变异系数=0.05=1-k0.968712346平均值 m=29.7标准值 k=m28.77075667统计频数 n=6k1=1.704/N0.5 0.695655087k2=4.678/N2 0.129944444K=0.825599531变异系数=0.22=1-k0.818368103平均值 m=27.4标准值 k=m22.42328

12、602统计频数 n=10k1=1.704/N0.5 0.538852113k2=4.678/N20.04678K=0.585632113变异系数=0.11=1-k0.935580468平均值 m=10.6标准值 k=m9.917152956统计频数 n=6k1=1.704/N0.5 0.695655087k2=4.678/N2 0.129944444K=0.825599531变异系数=0.04=1-k0.966976019平均值 m=33.1标准值 k=m32.00690622统计频数 n=24k1=1.704/N0.5 0.347827543k2=4.678/N2 0.008121528K=

13、0.355949071变异系数=0.16=1-k0.943048149平均值 m=11.7标准值 k=m11.03366334统计频数 n=6k1=1.704/N0.5 0.695655087k2=4.678/N2 0.129944444K=0.825599531变异系数=0.07=1-k0.942208033平均值 m=32标准值 k=m30.150657052层统计频数 n=8k1=1.704/N0.5 0.602454978k2=4.678/N20.07309375K=0.675548728变异系数=0.27=1-k0.817601844平均值m=21标准值k=m17.169638713

14、1层统计频数 n=11k1=1.704/N0.5 0.513775331k2=4.678/N2 0.038661157K=0.552436488变异系数=0.29=1-k0.839793418平均值m=27标准值k=m22.674422332层统计频数 n=6k1=1.704/N0.5 0.695655087k2=4.678/N2 0.129944444K=0.825599531变异系数=0.3=1-k0.752320141平均值m=15标准值k=m11.28480211统计频数 n=8k1=1.704/N0.50.602455k2=4.678/N20.073094K=0.675549变异系数

15、=0.21=1-k 0.858135平均值m=9标准值k=m 7.723213统计频数 n=11k1=1.704/N0.50.513775k2=4.678/N20.038661K=0.552436变异系数=0.12=1-k 0.933708平均值m=33.5标准值k=m 31.27921统计频数 n=6k1=1.704/N0.50.695655k2=4.678/N20.129944K=0.8256变异系数=0.46=1-k 0.620224平均值m=17.5标准值k=m 10.8539212层统计频数 n=7统计频数 n=k1=1.704/N0.50.644051k1=1.704/N0.5k2

16、=4.678/N20.095469k2=4.678/N2K=0.739521K=变异系数=0.382变异系数=1-k 0.717503=1-k平均值m=17.7平均值m=标准值k=m 12.6998标准值k=m2层统计频数 n=18统计频数 n=k1=1.704/N0.50.401637k1=1.704/N0.5k2=4.678/N20.014438k2=4.678/N2K=0.416075K=变异系数=0.22变异系数=1-k 0.908464=1-k平均值m=16.4平均值m=标准值k=m 14.8988标准值k=m3层统计频数 n=17统计频数 n=k1=1.704/N0.50.4132

17、81k1=1.704/N0.5k2=4.678/N20.016187k2=4.678/N2K=0.429468K=变异系数=0.466变异系数=1-k 0.799868=1-k平均值m=17.2平均值m=标准值k=m 13.75773标准值k=m41层统计频数 n=36统计频数 n=k1=1.704/N0.5 0.284k1=1.704/N0.5k2=4.678/N2 0.00361k2=4.678/N2K=0.28761K=变异系数=0.204变异系数=1-k 0.941328=1-k平均值m=18.2平均值m=标准值k=m 17.13216标准值k=m42层统计频数 n=33统计频数 n=

18、k1=1.704/N0.50.296628k1=1.704/N0.5k2=4.678/N20.004296k2=4.678/N2K=0.300924K=变异系数=0.28变异系数=1-k 0.915741=1-k平均值m=22.8平均值m=标准值k=m 20.8789标准值k=m5层统计频数 n=16统计频数 n=k1=1.704/N0.5 0.426k1=1.704/N0.5k2=4.678/N20.018273k2=4.678/N2K=0.444273K=变异系数=0.496变异系数=1-k0.77964=1-k平均值m=28.1平均值m=标准值k=m 21.90789标准值k=m70.6

19、440510.0954690.7395210.20.85209612.110.31036190.3909240.0129580.4038830.3590.85500611.59.83257170.4132810.0161870.4294680.3130.86557724.120.8604340.2922340.0040470.296280.210.93778198.44003330.2966280.0042960.3009240.2220.93319511.310.5451160.4260.0182730.4442730.3650.8378420.116.8405912层统计频数 n=10统计

20、频数 n=k1=1.704/N0.50.538852k1=1.704/N0.5k2=4.678/N2 0.04678k2=4.678/N2K=0.585632K=变异系数=0.18变异系数=1-k 0.894586=1-k平均值m=33.5平均值m=标准值k=m 29.96864标准值k=m21层统计频数 n=14统计频数 n=k1=1.704/N0.50.455413k1=1.704/N0.5k2=4.678/N20.023867k2=4.678/N2K=0.479281K=变异系数=0.19变异系数=1-k 0.908937=1-k平均值m=18.9平均值m=标准值k=m 17.1789标

21、准值k=m22层统计频数 n=20统计频数 n=k1=1.704/N0.50.381026k1=1.704/N0.5k2=4.678/N20.011695k2=4.678/N2K=0.392721K=变异系数=0.14变异系数=1-k 0.945019=1-k平均值m=15.4平均值m=标准值k=m 14.55329标准值k=m23层统计频数 n=34统计频数 n=k1=1.704/N0.50.292234k1=1.704/N0.5k2=4.678/N20.004047k2=4.678/N2K=0.29628K=变异系数=0.2变异系数=1-k 0.940744=1-k平均值m=15.5平均值

22、m=标准值k=m 14.58153标准值k=m41层统计频数 n=13统计频数 n=k1=1.704/N0.50.472605k1=1.704/N0.5k2=4.678/N2 0.02768k2=4.678/N2K=0.500285K=变异系数=0.24变异系数=1-k 0.879932=1-k平均值m=17.5平均值m=标准值k=m 15.3988标准值k=m100.5388520.046780.5856320.180.89458614.913.32933140.4554130.0238670.4792810.150.928108109.281079200.3810260.0116950.3

23、927210.140.9450198.78.221666340.2922340.0040470.296280.210.9377819.18.533808130.4726050.027680.5002850.230.88493410.89.55729212层统计频数 n=14统计频数k1=1.704/N0.50.455413k2=4.678/N20.023867K=0.479281变异系数=0.19变异系数=1-k 0.908937平均值m=35平均值标准值k=m 31.81278标准值21层统计频数 n=32统计频数k1=1.704/N0.50.301227k2=4.678/N20.00456

24、8K=0.305796变异系数=0.27变异系数=1-k 0.917435平均值m=18平均值标准值k=m 16.51383标准值22层统计频数 n=105统计频数k1=1.704/N0.50.166293k2=4.678/N20.000424K=0.166718变异系数=0.23变异系数=1-k 0.961655平均值m=13平均值标准值k=m 12.50151标准值23层统计频数 n=32统计频数k1=1.704/N0.50.301227k2=4.678/N20.004568K=0.305796变异系数=0.28变异系数=1-k 0.914377平均值m=16平均值标准值k=m 14.63

25、003标准值32层统计频数 n=10统计频数k1=1.704/N0.50.538852k2=4.678/N2 0.04678K=0.585632变异系数=0.24变异系数=1-k 0.859448平均值m=21平均值标准值k=m 18.04841标准值n=14k1=1.704/N0.50.455413k2=4.678/N20.023867K=0.479281=0.14=1-k 0.932901m=14.5k=m 13.52706n=32k1=1.704/N0.50.301227k2=4.678/N20.004568K=0.305796=0.14=1-k 0.957189m=11.6k=m 11

26、.10339n=105k1=1.704/N0.50.166293k2=4.678/N20.000424K=0.166718=0.12=1-k 0.979994m=9.6k=m 9.407941n=32k1=1.704/N0.50.301227k2=4.678/N20.004568K=0.305796=0.11=1-k 0.966362m=10.1k=m 9.760261n=10k1=1.704/N0.50.538852k2=4.678/N2 0.04678K=0.585632=0.14=1-k 0.918012m=21.6k=m 19.82905废水池21层统计频数n=27统计频数k1=1.7

27、04/N0.50.327934953k2=4.678/N20.00641701K=0.334351963变异系数=0.31变异系数=1-k0.896350892平均值m=13平均值标准值k=m11.65256159标准值21a层统计频数n=18统计频数k1=1.704/N0.50.401636652k2=4.678/N20.014438272K=0.416074923变异系数=0.37变异系数=1-k0.846052278平均值m=21平均值标准值k=m17.76709785标准值22层统计频数n=47统计频数k1=1.704/N0.50.248553946k2=4.678/N20.00211

28、77K=0.250671646变异系数=0.17变异系数=1-k0.95738582平均值m=17平均值标准值k=m16.27555894标准值31层统计频数n=24统计频数k1=1.704/N0.50.347827543k2=4.678/N20.008121528K=0.355949071变异系数=0.08变异系数=1-k0.971524074平均值m=30.5平均值标准值k=m29.63148427标准值33层统计频数n=24统计频数k1=1.704/N0.50.347827543k2=4.678/N20.008121528K=0.355949071变异系数=0.08变异系数=1-k0.9

29、71524074平均值m=30.5平均值标准值k=m29.63148427标准值n=27废水池k1=1.704/N0.50.327934953k2=4.678/N20.0064170113层统计频数n=10K=0.334351963k1=1.704/N0.50.53885211k2=4.678/N20.04678=0.49K=0.58563211=1-k0.836167538m=10.5变异系数=0.19k=m8.779759153=1-k0.8887299平均值m=18.5标准值k=m 16.4415031n=18k1=1.704/N0.50.401636652k2=4.678/N20.01

30、443827221层统计频数n=10K=0.416074923k1=1.704/N0.50.53885211k2=4.678/N20.04678=0.22K=0.58563211=1-k0.908463517m=25变异系数=0.1k=m22.71158792=1-k0.94143679平均值m=15.7标准值k=m 14.7805576n=47k1=1.704/N0.50.248553946k2=4.678/N20.002117722层统计频数n=7K=0.250671646k1=1.704/N0.50.64405146k2=4.678/N20.09546939=0.27K=0.739520

31、85=1-k0.932318656m=8变异系数=0.07k=m7.458549245=1-k0.94823354平均值m=18.2标准值k=m 17.2578504n=6k1=1.704/N0.50.695655087k2=4.678/N20.129944444K=0.825599531=0.04=1-k0.966976019m=37k=m35.77811269n=6k1=1.704/N0.50.695655087k2=4.678/N20.129944444K=0.825599531=0.04=1-k0.966976019m=37k=m35.7781126931层统计频数n=16k1=1.7

32、04/N0.50.426k2=4.678/N20.01827344K=0.44427344变异系数=0.35=1-k0.8445043平均值m=12.4标准值k=m 10.4718533统计频数n=6k1=1.704/N0.50.69565509k2=4.678/N20.12994444K=0.82559953变异系数=0.29=1-k0.76057614平均值m=26.6标准值k=m 20.2313252统计频数 n=10k1=1.704/N0.5 0.538852113k2=4.678/N20.04678K=0.585632113变异系数=0.16=1-k0.906298862平均值m=9

33、.3标准值k=m8.428579415统计频数 n=10k1=1.704/N0.5 0.538852113k2=4.678/N20.04678K=0.585632113变异系数=0.09=1-k0.94729311平均值m=8.9标准值k=m8.430908677统计频数 n=7k1=1.704/N0.5 0.644051462k2=4.678/N20.095469388K=0.73952085变异系数=0.02=1-k0.985209583平均值m=10.6标准值k=m10.44322158统计频数 n=16k1=1.704/N0.50.426k2=4.678/N20.018273438K=

34、0.444273438变异系数=0.08=1-k0.964458125平均值m=31标准值k=m29.89820188统计频数 n=6k1=1.704/N0.5 0.695655087k2=4.678/N20.129944444K=0.825599531变异系数=0.738=1-k0.390707546平均值m=13.8标准值k=m5.39176413221层统计频数 n=33k1=1.704/N0.50.296628326k2=4.678/N20.004295684K=0.30092401变异系数=0.36=1-k0.891667356平均值m=15标准值k=m13.3750103522层统

35、计频数 n=18k1=1.704/N0.50.401636652k2=4.678/N20.014438272K=0.416074923变异系数=0.26=1-k0.89182052平均值m=15标准值k=m13.377307831层统计频数 n=11k1=1.704/N0.50.513775331k2=4.678/N20.038661157K=0.552436488变异系数=1.17=1-k0.353649309平均值m=7标准值k=m2.475545162统计频数n=33k1=1.704/N0.50.296628326k2=4.678/N20.004295684K=0.30092401变异系数=0.36=1-k0.891667356平均值m=13标准值k=m11.59167563统计频数n=18k1=1.704/N0.50.401636652k2=4.678/N20.014438272K=0.416074923变异系数=0.23=1-k0.904302768平均值m=10标准值k=m9.043027676统计频数n=11k1=1.704/N0.50.513775331k2=4.678/N20.038661157K=0.552436488变异系数=0.45=1-k0.75140358平均值m=27.5标准值k=m20.66359846