用原始数据采用Z分法制作评分表模板

用原始数据采用Z分法制作评分表模板选项数据类型：田赛1径赛原始数据输入：得分6.006.706.006.206.005.906.056.305.906.456.156.406.006.056.306.306.506.206.336.105.755.956.306.206.006.556.006.136.206.686.506.575.706.186.206.156.256.256.104.906.4561736164615962665969636861626666706467625660666461706163647370715564646365656241691获得统计量平均值标准差总人数6.810.71275平均分插值:基准点的宽度:758评分表得分1009998979695949392919089888786858483828180797877767574737271706968676665646362616059成绩8.238.178.118.068.007.947.897.837.777.727.667.607.557.497.437.387.327.267.217.157.097.046.986.926.876.816.756.706.646.586.536.476.416.366.306.246.196.136.076.025.965.90等级优秀良好中及格不及格结果分析人数百分比2910.556925.099032.736824.73196.91操作方法：1、输入数据类型1或者2。2、原始数据输入A列。3、可调整基准点的宽度4-10之间，看结果分析中的百分比是否附合正态分布。6.456.156.156.456.706.055.606.006.556.206.355.956.156.856.256.205.905.955.806.506.25.866.66.476.16.16.806.306.006.206.006.006.406.606.106.305.906.406.705.806.306.206.006.055.70696363697362546170646760637665645960577064576171687862627566616461616871626659687357666461625558575655545352515049484746454443424140393837363534333231302928272625242322212019181716151413125.845.795.735.675.625.565.505.455.395.335.285.225.165.115.054.994.944.884.824.774.714.654.604.544.484.434.374.314.264.204.144.094.033.973.923.863.803.753.693.633.583.523.463.413.353.293.245.706.005.636.256.156.136.006.005.935.906.007.707.407.707.507.907.207.608.2088.87.2877.27.18.97.907.807.607.107.707.807.907.807.508.407.507.108.307.608.407.107.508.507.107.1055615465636361616059619185918794828910096110829678828011294928980919294928710387801018910380871058080111098765432103.183.123.073.012.952.902.842.782.732.672.612.567.507.407.907.907.207.608.107.407.607.107.907.207.807.507.708.207.407.707.507.507.907.207.608.206.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.588785949482899885898094829287911008591878794828910071717171717171717171717171717171717171717171716.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.586.5871717171717171717171717171717171717171717171717171717171717171717171717171717171717171717171716.586.586.586.586.586.586.587.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.507.5010.007171717171717187878787878787878787878787878787878787878787878787878787878787878787878787871310000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000