数据标准化处理.xls

12345商品名称大 米 面 粉 面 粉豆制品花生油规格等级粳米富强粉标准粉豆腐压榨一级单位千克千克千克千克升1月1-10日15.925.484.54.4327.311月11-20日25.915.474.484.4227.241月21-30日35.925.494.494.4627.172月1-10日45.935.494.494.4827.212月11-20日55.935.54.494.4627.282月21-28日65.935.54.494.4627.33月1-10日75.945.484.54.4727.233月11-20日85.945.54.54.4627.183月21-30日95.955.584.54.4727.234月1-10日105.955.64.494.4827.16最小值5.915.474.484.4227.16最大值5.955.64.54.4827.31 差0.040.130.020.060.15商品名称大 米 面 粉 面 粉豆制品花生油规格等级粳米富强粉标准粉豆腐压榨一级数据标准化10.25 0.0769230771 0.1666666671200000.53333333330.25 0.1538461540.5 0.6666666670.06666666740.5 0.1538461540.510.33333333350.5 0.2307692310.5 0.6666666670.860.5 0.2307692310.5 0.6666666670.93333333370.75 0.0769230771 0.8333333330.46666666780.75 0.2307692311 0.6666666670.13333333391 0.8461538461 0.8333333330.46666666710110.510粮食及制品豆制品食用油肉及其制品 蛋及其蛋制品 数据平均化10.442307692 0.166666667 0.66666667 0.43040150812000.7188962 0.4108305540.98461538530.301282051 0.6666666670.6433845 0.8448847070.90769230840.3846153851 0.74269006 0.8124761740.72307692350.41025641 0.666666667 0.89495614 0.6528535320.26153846260.41025641 0.666666667 0.841812870.4123168070.608974359 0.8333333330.7005117 0.3602094330.07692307780.66025641 0.666666667 0.51209795 0.2588989550.44615384690.948717949 0.833333333 0.53220029 0.2403503480.538461538100.8333333331 0.13541667 0.2388167390.523076923粮粮食食及及制制品品12108642000.10.20.30.40.50.60.70.80.91粮食及制品豆豆制制品品12108642000.20.40.60.811.2豆制品大大 米米 粳粳米米12108642000.20.40.60.811.2大 米 粳米面面 粉粉 富富强强粉粉12108642000.20.40.60.811.2面 粉 富强粉肉肉及及其其制制品品12108642000.10.20.30.40.50.60.70.80.9肉及其制品蛋蛋及及其其蛋蛋制制品品12108642000.20.40.60.811.2蛋及其蛋制品蔬蔬菜菜水水果果类类12108642000.10.20.30.40.50.60.70.80.91蔬菜水果类粮粮食食及及制制品品12108642000.10.20.30.40.50.60.70.80.91粮食及制品豆豆制制品品12108642000.20.40.60.811.2豆制品花花生生油油 压压榨榨一一级级12108642000.20.40.60.811.2花生油 压榨一级大大豆豆油油 5L5L桶桶装装12108642000.20.40.60.811.2大豆油 5L桶装猪猪 肉肉 猪猪肉肉后后臀臀尖尖(后后腿腿肉肉)12108642000.20.40.60.811.2猪 肉 猪肉后臀尖(后腿肉)猪猪 肉肉 五五花花肉肉12108642000.20.40.60.811.2猪 肉 五花肉羊羊 肉肉 腿腿肉肉12108642000.20.40.60.811.2羊 肉 腿肉鸡鸡 白白条条鸡鸡12108642000.20.40.60.811.2鸡 白条鸡大大 米米 粳粳米米12108642000.20.40.60.811.2大 米 粳米面面 粉粉 富富强强粉粉12108642000.20.40.60.811.2面 粉 富强粉鸭鸭 白白条条鸭鸭12108642000.20.40.60.811.2鸭 白条鸭鸡鸡 蛋蛋 散散装装鲜鲜鸡鸡蛋蛋12108642000.20.40.60.811.2鸡 蛋 散装鲜鸡蛋活活草草鱼鱼12108642000.20.40.60.811.2活草鱼带带 鱼鱼12108642000.20.40.60.811.2带 鱼羊羊 肉肉 腿腿肉肉12108642000.20.40.60.811.2羊 肉 腿肉鸡鸡 白白条条鸡鸡12108642000.20.40.60.811.2鸡 白条鸡6789101112大豆油菜籽油猪 肉猪 肉牛 肉 羊 肉鸡5L桶装一级散装 猪肉后臀尖(后腿肉)五花肉腿肉腿肉白条鸡升升千克千克千克千克千克11.2413.7826.326.2766.3766.4818.7711.2114.0326.0426.0566.666.4118.7911.2214.0926.0526.267.5667.5818.9911.2214.125.9625.9867.9267.8318.9611.2314.0825.0424.9867.3767.5918.7911.2114.0224.3424.366.8667.2418.7711.231423.8423.8266.6566.9218.7811.1814.0123.2923.2566.5366.718.7811.1413.9922.6422.6866.4566.5118.8411.0513.9122.1522.2166.3166.3918.9311.0513.7822.1522.2166.3166.3918.7711.2414.126.326.2767.9267.8318.990.190.324.154.061.611.440.22大豆油菜籽油猪 肉猪 肉牛 肉 羊 肉鸡5L桶装一级散装 猪肉后臀尖(后腿肉)五花肉腿肉腿肉白条鸡1011 0.0372670810.062500.8421050.781250.9373493980.945812808 0.180124224 0.01388889 0.0909090.8947370.968750.9397590360.982758621 0.776397516 0.8263888910.89473710.9180722890.92857142911 0.8636360.9473680.93750.6963855420.68226601 0.658385093 0.83333333 0.0909090.8421050.750.5277108430.514778325 0.341614907 0.5902777800.9473680.68750.4072289160.396551724 0.211180124 0.36805556 0.0454550.6842110.718750.2746987950.256157635 0.136645963 0.21527778 0.0454550.4736840.656250.1180722890.115763547 0.086956522 0.08333333 0.31818200.406250000 0.727273水产类蔬菜水果类合计0.0400880.1339374372.920.1127640.2078206492.590.813660.725826465.5210.9189285396.410.5526030.7108623454.920.367390.6808546244.140.2640410.6806158184.330.1955620.6327667534.180.1692280.5287582274.620.172170.4536506144.2食食用用油油12108642000.10.20.30.40.50.60.70.80.91食用油豆豆制制品品12108642000.20.40.60.811.2豆制品面面 粉粉 标标准准粉粉12108642000.20.40.60.811.2面 粉 标准粉水水产产类类12108642000.20.40.60.811.2水产类豆豆制制品品12108642000.20.40.60.811.2豆制品面面 粉粉 富富强强粉粉12108642000.20.40.60.811.2面 粉 富强粉蛋蛋及及其其蛋蛋制制品品12108642000.20.40.60.811.2蛋及其蛋制品食食用用油油12108642000.10.20.30.40.50.60.70.80.91食用油菜菜籽籽油油 一一级级散散装装12108642000.20.40.60.811.2菜籽油 一级散装牛牛 肉肉 腿腿肉肉908070605040302010000.20.40.60.811.2牛 肉 腿肉鸡鸡 鸡鸡胸胸肉肉12108642000.20.40.60.811.2鸡 鸡胸肉面面 粉粉 富富强强粉粉12108642000.20.40.60.811.2面 粉 富强粉大大豆豆油油 5L5L桶桶装装12108642000.20.40.60.811.2大豆油 5L桶装猪猪 肉肉 五五花花肉肉12108642000.20.40.60.811.2猪 肉 五花肉鸡鸡 白白条条鸡鸡12108642000.20.40.60.811.2鸡 白条鸡面面 粉粉 标标准准粉粉12108642000.20.40.60.811.2面 粉 标准粉活活鲤鲤鱼鱼12108642000.20.40.60.811.2活鲤鱼大大白白菜菜12108642000.20.40.60.811.2大白菜鸡鸡 白白条条鸡鸡12108642000.20.40.60.811.2鸡 白条鸡鸡鸡 蛋蛋 散散装装鲜鲜鸡鸡蛋蛋12108642000.20.40.60.811.2鸡 蛋 散装鲜鸡蛋带带 鱼鱼12108642000.20.40.60.811.2带 鱼鸡鸡 鸡鸡胸胸肉肉12108642000.20.40.60.811.2鸡 鸡胸肉131415161718192021鸡鸭鸡 蛋活鲤鱼活草鱼带 鱼大白菜油 菜芹 菜鸡胸肉白条鸭散装鲜鸡蛋千克千克千克千克千克千克千克千克千克20.7816.4410.0613.9316.4730.232.114.665.5520.7216.4610.0513.9616.4130.72.074.655.4720.816.581014.917.2631.92.225.235.9820.7516.519.8815.2217.532.12.425.526.0420.7116.89.5814.511731.412.355.285.5820.6216.699.4114.2616.7931.072.265.415.420.716.639.4614.0816.6730.942.225.415.3120.6216.689.713.9616.5730.892.285.375.3620.5816.779.7613.8716.5230.952.415.045.2120.5716.789.7513.8416.5330.992.574.794.9520.5716.449.4113.8416.4130.232.074.654.9520.816.810.0615.2217.532.12.575.526.040.230.360.651.381.091.870.50.871.09鸡鸭鸡 蛋活鲤鱼活草鱼带 鱼大白菜油 菜芹 菜鸡胸肉白条鸭散装鲜鸡蛋0.91304301 0.065217 0.05504600.08 0.011494 0.5504590.652174 0.055556 0.984615 0.0869570 0.25133700 0.4770641 0.388889 0.907692 0.768116 0.779817 0.8930480.3 0.666667 0.9449540.782609 0.194444 0.7230771110.7110.6086961 0.261538 0.485507 0.541284 0.6310160.56 0.724138 0.5779820.217391 0.6944440 0.304348 0.348624 0.4491980.38 0.873563 0.4128440.565217 0.527778 0.076923 0.173913 0.238532 0.3796790.3 0.873563 0.3302750.217391 0.666667 0.446154 0.086957 0.146789 0.3529410.42 0.827586 0.3761470.043478 0.916667 0.538462 0.021739 0.100917 0.3850270.68 0.448276 0.2385320 0.944444 0.5230770 0.110092 0.40641710.160920食食用用油油12108642000.10.20.30.40.50.60.70.80.91食用油豆豆制制品品 豆豆腐腐12108642000.20.40.60.811.2豆制品 豆腐合合计计12108642001234567合计食食用用油油12108642000.10.20.30.40.50.60.70.80.91食用油面面 粉粉 标标准准粉粉12108642000.20.40.60.811.2面 粉 标准粉水水产产类类12108642000.20.40.60.811.2水产类油油 菜菜12108642000.20.40.60.811.2油 菜西西红红柿柿12108642000.20.40.60.811.2西红柿土土 豆豆12108642000.20.40.60.811.2土 豆面面 粉粉 标标准准粉粉12108642000.20.40.60.811.2面 粉 标准粉菜菜籽籽油油 一一级级散散装装12108642000.20.40.60.811.2菜籽油 一级散装牛牛 肉肉 腿腿肉肉908070605040302010000.20.40.60.811.2牛 肉 腿肉鸡鸡 鸡鸡胸胸肉肉12108642000.20.40.60.811.2鸡 鸡胸肉豆豆制制品品 豆豆腐腐12108642000.20.40.60.811.2豆制品 豆腐香香 蕉蕉 国国产产12108642000.20.40.60.811.2香 蕉 国产鸡鸡 鸡鸡胸胸肉肉12108642000.20.40.60.811.2鸡 鸡胸肉活活鲤鲤鱼鱼12108642000.20.40.60.811.2活鲤鱼大大白白菜菜12108642000.20.40.60.811.2大白菜土土 豆豆12108642000.20.40.60.811.2土 豆222324252627黄 瓜西红柿豆 角土 豆苹 果香 蕉富士苹果国产千克千克千克千克千克千克5.967.8912.954.2611.16.526.248.213.934.311.26.718.299.0117.394.4911.637.178.49.0817.344.6811.797.457.948.5614.654.6411.757.517.858.8113.754.6311.757.517.639.0313.744.6311.817.587.018.5113.294.6411.97.526.537.7312.634.6211.967.586.067.3111.584.6311.987.695.967.3111.584.2611.16.528.49.0817.394.6811.987.692.441.775.810.420.881.17黄 瓜西红柿豆 角土 豆苹 果香 蕉富士苹果国产0 0.3276840.23580000.114754 0.502825 0.404475 0.095238 0.113636 0.1623930.954918 0.9604521 0.547619 0.602273 0.55555611 0.9913941 0.784091 0.7948720.811475 0.706215 0.528399 0.904762 0.738636 0.8461540.77459 0.847458 0.373494 0.880952 0.738636 0.8461540.684426 0.971751 0.371773 0.880952 0.806818 0.9059830.430328 0.6779660.29432 0.904762 0.909091 0.8547010.233607 0.237288 0.180723 0.857143 0.977273 0.9059830.04098400 0.88095211芹芹 菜菜12108642000.20.40.60.811.2芹 菜豆豆制制品品 豆豆腐腐12108642000.20.40.60.811.2豆制品 豆腐黄黄 瓜瓜12108642000.20.40.60.811.2黄 瓜豆豆 角角12108642000.20.40.60.811.2豆 角苹苹 果果 富富士士苹苹果果12108642000.20.40.60.811.2苹 果 富士苹果豆豆制制品品 豆豆腐腐12108642000.20.40.60.811.2豆制品 豆腐油油 菜菜12108642000.20.40.60.811.2油 菜西西红红柿柿12108642000.20.40.60.811.2西红柿土土 豆豆12108642000.20.40.60.811.2土 豆芹芹 菜菜12108642000.20.40.60.811.2芹 菜土土 豆豆12108642000.20.40.60.811.2土 豆香香 蕉蕉 国国产产12108642000.20.40.60.811.2香 蕉 国产苹苹 果果 富富士士苹苹果果12108642000.20.40.60.811.2苹 果 富士苹果