分位_人力资源管理_经管营销_专业资料.xls

《分位_人力资源管理_经管营销_专业资料.xls》由会员分享，可在线阅读，更多相关《分位_人力资源管理_经管营销_专业资料.xls（6页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、分分位位函函数数为为PERCENTILE(PERCENTILE(数数据据系系列列，0.10.1，0.250.25，0.500.50，0.75,0.90)0.75,0.90)行行政政主主管管序序号号工工资资1010分分位位2525分分位位5050分分位位7575分分位位1 1200020002 2300030003 3250025004 4240024005 5200020006 6210021007 7220022008 8280028009 9275027501010263026301111277027701212225022501313240024001414250025001515265

2、026501616276027601717285028501818290029001919245024502020260026009090分分位位分分位位函函数数为为PERCENTILE(PERCENTILE(数数据据系系列列，0.10.1，0.250.25，0.500.50，0.75,0.90)0.75,0.90)分分位位函函数数为为PERCENTILE(PERCENTILE(数数据据系系列列，0.10.1，0.250.25，0.500.50，0.75,0.90)0.75,0.90)行行政政主主管管序序号号工工资资1010分分位位2525分分位位5050分分位位7575分分位位1 13200

3、32002 2300030003 3350035004 4345034505 5360036006 6380038007 7400040008 8420042009 9370037001010395039501111355035501212343034301313352035201414300030001515377037701616349034901717328032801818310031001919325032502020334033409090分分位位分分位位函函数数为为PERCENTILE(PERCENTILE(数数据据系系列列，0.10.1，0.250.25，0.500.50，0.

4、75,0.90)0.75,0.90)分分位位函函数数为为PERCENTILE(PERCENTILE(数数据据系系列列，0.10.1，0.250.25，0.500.50，0.75,0.90)0.75,0.90)行行政政主主管管序序号号工工资资1010分分位位2525分分位位5050分分位位7575分分位位1 1400040002 2410041003 3425042504 4440044005 5435043506 6469046907 7421042108 8380038009 9398039801010450045001111520052001212500050001313478047801414460046001515441044101616485048501717490049001818429042901919455045502020465046509090分分位位分分位位函函数数为为PERCENTILE(PERCENTILE(数数据据系系列列，0.10.1，0.250.25，0.500.50，0.75,0.90)0.75,0.90)