第3章 数据描述分析计算结果.xls
序号X110105522020203303030440404055052350均值30.00124.6039.00中位数30.0030.0040.00众数#N/A#N/A#N/A年龄2224292929303131323740414444464950525758均值38.75=AVERAGE(B2:B21)中位数38.5=MEDIAN(B2:B21)众数29=MODE(B2:B21)切尾平均数38.75=TRIMMEAN(B2:B21,0.05)总体标准差 10.6154369=STDEVP(B2:B21)最小值22=QUARTILE(B2:B21,0)第1四分位数29.75=QUARTILE(B2:B21,1)第2四分位数38.5=QUARTILE(B2:B21,2)第3四分位数46.75=QUARTILE(B2:B21,3)最大值58=QUARTILE(B2:B21,4)四分位距17=B30-B28偏态0.27701322=SKEW(B2:B21)峰度-1.0811953=KURT(B2:B21)样本值样本数123456717-10月-99142197014458521406897143685914462711434959142012818-10月-99144435714156181409933142954414466011410771140065719-10月-99144989214316351427423143611814081081405997140092620-10月-99140008814431161410786140969414064251418465140502121-10月-99142317514061261416449142067114271921413840142150522-10月-99140144214292021426506142436314081831405559141034523-10月-99140242614272571408280140398114182201411746141928024-10月-99141347514142451403137142642214063811432664143730025-10月-99140740514176661446294142825414281101405154140639926-10月-991360000135000014468061432533140385514738981440723质量控制图1234567891014000001410000142000014300001440000样本数样本均值1388391 1388391 13883911388391138839102000004000006000008000001000000120000014000001600000系列2系列31388391 1388391 13883911388391138839102000004000006000008000001000000120000014000001600000系列2系列38样本均值中心线样本标准差 控制下限控制上限1426424142992014191881360713883911449984143047514234951419188168351388391144998414297461423731141918817024138839114499841410238141297914191881327713883911449984142648414194301419188704113883911449984140910814143391419188106511388391144998414074191412326141918885731388391144998414291601420348141918812702138839114499841413903141914814191881427413883911449984143075614173211419188431431388391144998415713XX2030 平均11840 标准误差 80.7436342 中值4155 模式#N/A521 标准偏差 197.7807样本方差39117.2峰值5.92557偏斜度2.429919区域501最小值20最大值521求和708计数6喷发时间 间隔时间接收频率14.47842113.97446414685061476532413.580571514.18461812.35065914.79369811.755721814.976763911.758801914.674844013.475871724.380911121.756 其他323.98023.76923.157249021.84224.19121.85123.27921.95324.682225134.57633.98234.38432.35333.88631.95134.68531.84534.78831.85134.68031.94933.582447543.77343.76744.36843.68643.87243.87543.87542.56644.58444.17043.77943.86043.486547152.36754.481直方图42 46 50 53 57 61 65 69 72 76 80 84 87 91其他051015202530354045接收频率54.17654.38353.376525554.37352.95654.68351.95753.67153.77253.77761.85564.67563.573647063.78361.75064.69561.751648261.85464.48361.95164.68062.97873.581725374.38971.84474.17871.86174.77374.27573.97374.37671.85574.586724884.27784.47384.17084.188847584.18382.76184.67881.96184.581825184.88084.179164.182164.280164.576161.956164.78216247164.776162.561164.375164.472164.474164.369164.678162.152174.891174.1661747117475174.481174.177174.37417470173.983173.253174.582172.262174.773174.684182.258184.882184.377183.87518477184.177181.853184.47518478182.251185.181181.95218576184.473194.584193.872194.389194.475192.257194.881191.949194.787191.843194.89419245194.481192.559194.382204.480201.954204.775204.373202.257204.780202.351204.677203.366204.277202.960204.686203.362204.275202.667204.669213.784211.858214.790214.582214.571214.88021251214.880211.962214.78421251215.181214.383214.88422372222.154224.67522474222.251225.191222.960224.380222.154224.780224.570221.760224.286224.378231.751234.483234.276232.251234.79023471231.849234.788231.852234.579232.161234.281232.148235.28423263直方图42 46 50 53 57 61 65 69 72 76 80 84 87 91其他051015202530354045接收频率
