第3章数据描述分析计算结果.xls

序号x 1101055 2202020 3303030 4404040 55052350 均值30.00124.6039.00 中位数30.0030.0040.00 众数#n/a#n/a#n/a 年龄 22 24 29 29 29 30 31 31 32 37 40 41 44 44 46 49 50 52 57 58 均值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) 样本数1234567 17-十月-991421970144585214068971436859144627114349591420128 18-十月-991444357141561814099331429544144660114107711400657 19-十月-991449892143163514274231436118140810814059971400926 20-十月-991400088144311614107861409694140642514184651405021 21-十月-991423175140612614164491420671142719214138401421505 22-十月-991401442142920214265061424363140818314055591410345 23-十月-991402426142725714082801403981141822014117461419280 24-十月-991413475141424514031371426422140638114326641437300 25-十月-991407405141766614462941428254142811014051541406399 26-十月-991360000135000014468061432533140385514738981440723 样本值 1400000 1405000 1410000 1415000 1420000 1425000 1430000 1435000 12345678910 样本均值 样本数 质量控制图 0 500000 1000000 1500000 2000000 系列2 系列3 8样本均值中心线样本标准差 控制下限控制上限 1426424142992014191881360713883911449984 1430475142349514191881683513883911449984 1429746142373114191881702413883911449984 1410238141297914191881327713883911449984 142648414194301419188704113883911449984 1409108141433914191881065113883911449984 140741914123261419188857313883911449984 1429160142034814191881270213883911449984 1413903141914814191881427413883911449984 1430756141732114191884314313883911449984 15713 xx 20 30 平均118 40 标准误差80.74363 42 中值41 55 模式#n/a 521 标准偏差197.7807 样本方差39117.2 峰值5.92557 偏斜度2.429919 区域501 最小值20 最大值521 求和708 计数6 喷发时间 间隔时间接收频率 14.478421 13.974464 1468506 14765324 13.5805715 14.184618 12.350659 14.793698 11.7557218 14.9767639 11.7588019 14.6748440 13.4758717 24.3809111 21.756 其他3 23.980 23.769 23.157 2490 21.842 24.191 21.851 23.279 21.953 24.682 2251 34.576 33.982 34.384 32.353 33.886 31.951 34.685 31.845 34.788 31.851 34.680 31.949 33.582 4475 43.773 43.767 44.368 43.686 43.872 43.875 43.875 42.566 44.584 44.170 43.779 43.860 43.486 5471 52.367 0 5 10 15 20 25 30 35 40 45 4250576572 频率 接收 直方图 54.481 54.176 54.383 53.376 5255 54.373 52.956 54.683 51.957 53.671 53.772 53.777 61.855 64.675 63.573 6470 63.783 61.750 64.695 61.751 6482 61.854 64.483 61.951 64.680 62.978 73.581 7253 74.389 71.844 74.178 71.861 74.773 74.275 73.973 74.376 71.855 74.586 7248 84.277 84.473 84.170 84.188 8475 84.183 82.761 84.678 81.961 84.581 8251 84.880 84.179 164.182 164.280 164.576 161.956 164.782 16247 164.776 162.561 164.375 164.472 164.474 164.369 164.678 162.152 174.891 174.166 17471 17475 174.481 174.177 174.374 17470 173.983 173.253 174.582 172.262 174.773 174.684 182.258 184.882 184.377 183.875 18477 184.177 181.853 184.475 18478 182.251 185.181 181.952 18576 184.473 194.584 193.872 194.389 194.475 192.257 194.881 191.949 194.787 191.843 194.894 19245 194.481 192.559 194.382 204.480 201.954 204.775 204.373 202.257 204.780 202.351 204.677 203.366 204.277 202.960 204.686 203.362 204.275 202.667 204.669 213.784 211.858 214.790 214.582 214.571 214.880 21251 214.880 211.962 214.784 21251 215.181 214.383 214.884 22372 222.154 224.675 22474 222.251 225.191 222.960 224