人事管理制度样例

Sheet1 学号 姓名 管理学基础 国际贸易 经济学基础 外贸英语听说 英语 总分 总分排名 管理学基础z 国际贸易分z 经济学基础z 外贸英语听说z 英语z z总分 z总分排名 204060108 罗晨 86 93 88 81 71 419 1 1.2823410714 1.6732580345 1.9754287787 0.4243205618 0.7224954436 6.07784389 1 204060111 李楚楚 82 94 76 95 70 417 2 1.0226994597 1.7670271647 0.9967759892 1.6019503149 0.6227644774 6.0112174059 2 204060101 范娟萍 84 84 77 92 79 416 3 1.1525202655 0.8293358627 1.0783303884 1.3496010821 1.5203431727 5.9301307713 3 204060113 陈虹辰 89 83 72 90 78 412 4 1.4770722802 0.7355667325 0.6705583928 1.1813682602 1.4206122066 5.4851778722 4 204060114 余苏仙 82 90 75 88 70 405 5 1.0226994597 1.3919506439 0.9152215901 1.0131354383 0.6227644774 4.9657716094 5 204060145 戴超军 83 84 77 88 70 402 6 1.0876098626 0.8293358627 1.0783303884 1.0131354383 0.6227644774 4.6311760294 6 204060104 蒋国平 77 83 76 94 69 399 7 0.698147445 0.7355667325 0.9967759892 1.5178339039 0.5230335113 4.4713575819 7 204060103 张淑文 82 91 71 78 74 396 8 1.0226994597 1.4857197741 0.5890039936 0.171971329 1.021688342 4.2910828984 8 204060141 林丽君 79 84 89 85 56 393 9 0.8279682508 0.8293358627 2.0569831778 0.7607862055 -0.7734690485 3.7016044483 10 204060112 罗晨鸣 77 87 69 92 67 392 10 0.698147445 1.1106432533 0.4258951954 1.3496010821 0.323571579 3.9078585547 9 204060118 施月琴 75 77 72 94 68 386 11 0.5683266391 0.1729519513 0.6705583928 1.5178339039 0.4233025452 3.3529734322 11 204060117 黄蓓蓓 73 86 69 86 70 384 12 0.4385058332 1.0168741231 0.4258951954 0.8449026165 0.6227644774 3.3489422456 12 204060106 叶芬 77 78 74 75 76 380 13 0.698147445 0.2667210815 0.833667191 -0.0803779038 1.2211502743 2.9393080879 13 204060126 郭玉洁 84 74 73 78 70 379 14 1.1525202655 -0.1083554393 0.7521127919 0.171971329 0.6227644774 2.5910134245 17 204060105 赖敏波 75 90 63 78 71 377 15 0.5683266391 1.3919506439 -0.0634311993 0.171971329 0.7224954436 2.7913128563 14 204060134 吴丽晓 67 79 72 87 71 376 16 0.0490434156 0.3604902117 0.6705583928 0.9290190274 0.7224954436 2.731606491 15 204060102 徐旭东 77 88 61 83 67 376 17 0.698147445 1.2044123835 -0.2265399976 0.5925533837 0.323571579 2.5921447936 16 204060127 朱海灯 74 84 80 78 56 372 18 0.5034162361 0.8293358627 1.3229935857 0.171971329 -0.7734690485 2.054247965 18 204060119 楼周华 81 78 69 76 66 370 19 0.9577890567 0.2667210815 0.4258951954 0.0037385072 0.2238406129 1.8779844536 19 204060116 江萍 80 72 73 79 64 368 20 0.8928786538 -0.2958936998 0.7521127919 0.2560877399 0.0243786806 1.6295641665 20 204060120 毛胜侠 77 76 62 80 70 365 21 0.698147445 0.0791828211 -0.1449855984 0.3402041509 0.6227644774 1.5953132959 21 204060124 陈晓群 70 83 60 79 69 361 22 0.2437746244 0.7355667325 -0.3080943967 0.2560877399 0.5230335113 1.4503682114 22 204060122 林璐璐 65 80 62 80 71 358 23 -0.0807773903 0.4542593419 -0.1449855984 0.3402041509 0.7224954436 1.2911959476 23 204060123 刘广平 69 79 62 74 72 356 24 0.1788642214 0.3604902117 -0.1449855984 -0.1644943147 0.8222264097 1.0521009297 24 204060125 林淑瑜 56 74 62 78 76 346 25 -0.6649710168 -0.1083554393 -0.1449855984 0.171971329 1.2211502743 0.4748095487 25 204060121 龚佳佳 70 70 62 79 63 344 26 0.2437746244 -0.4834319602 -0.1449855984 0.2560877399 -0.0753522855 -0.2039074798 27 204060109 鲍超 53 66 60 87 73 339 27 -0.8597022256 -0.858508481 -0.3080943967 0.9290190274 0.9219573759 -0.1753287 26 204060132 李锋 57 83 69 62 66 337 28 -0.6000606138 0.7355667325 0.4258951954 -1.1738912459 0.2238406129 -0.388649319 28 204060115 陈赛华 61 71 66 78 57 333 29 -0.3404190021 -0.38966283 0.181231998 0.171971329 -0.6737380824 -1.0506165873 29 204060142 刘洋 65 63 60 79 61 328 30 -0.0807773903 -1.1398158716 -0.3080943967 0.2560877399 -0.2748142178 -1.5474141364 31 204060130 陈瑞克 56 65 60 75 71 327 31 -0.6649710168 -0.9522776112 -0.3080943967 -0.0803779038 0.7224954436 -1.2832254848 30 204060128 杨正超 60 64 68 70 64 326 32 -0.405329405 -1.0460467414 0.3443407963 -0.5009599584 0.0243786806 -1.5836166279 32 204060107 徐晓笛 70 72 66 51 62 321 33 0.2437746244 -0.2958936998 0.181231998 -2.0991717661 -0.1750832517 -2.1451420951 33 204060110 周海波 73 73 52 60 50 308 34 0.4385058332 -0.2021245695 -0.9605295896 -1.3421240678 -1.3718548453 -3.4381272391 35 204060143 卓旭平 43 75 60 80 49 307 35 -1.508806255 -0.0145863091 -0.3080943967 0.3402041509 -1.4715858115 -2.9628686214 34 204060129 王金培 53 64 47 65 67 296 36 -0.8597022256 -1.0460467414 -1.3683015852 -0.9215420131 0.323571579 -3.8720209863 36 204060137 朱永强 54 57 50 69 62 292 37 -0.7947918227 -1.7024306528 -1.1236383879 -0.5850763694 -0.1750832517 -4.3810204844 37 204060144 黄行 54 53 44 68 57 276 38 -0.7947918227 -2.0775071736 -1.6129647826 -0.6691927803 -0.6737380824 -5.8281946415 38 204060131 张晓伟 64 62 48 60 37 271 39 -0.1456877933 -1.2335850018 -1.2867471861 -1.3421240678 -2.6683574051 -6.676501454 40 204060135 李征峰 39 60 61 52 52 264 40 -1.7684478668 -1.4211232622 -0.2265399976 -2.0150553552 -1.1723929131 -6.6035593948 39 204060133 周凯 47 62 36 65 44 254 41 -1.2491646432 -1.2335850018 -2.2653999755 -0.9215420131 -1.9702406422 -7.6399322758 43 204060138 蒋授 29 60 52 60 52 253 42 -2.4175518962 -1.4211232622 -0.9605295896 -1.3421240678 -1.1723929131 -7.3137217288 41 204060139 陈惺 32 65 50 50 53 250 43 -2.2228206873 -0.9522776112 -1.1236383879 -2.1832881771 -1.0726619469 -7.5546868104 42 204060140 汤陈洁 39 66 39 60 46 250 44 -1.7684478668 -0.858508481 -2.0207367782 -1.3421240678 -1.7707787099 -7.7605959036 44 204060136 叶世杰 41 60 36 60 42 239 45 -1.6386270609 -1.4211232622 -2.2653999755 -1.3421240678 -2.1697025744 -8.8369769408 45 平均分 66.2444444444 75.1555555556 63.7777777778 75.9555555556 63.7555555556 标准差S 15.405851061 10.6644905188 12.2617542499 11.8882865891 10.0269759606Sheet2 Sheet3