- ©«¤l
- 85
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 126
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-8-31
- ³Ì«áµn¿ý
- 2022-4-15
|
¥»©«³Ì«á¥Ñ KCC ©ó 2017-6-3 15:00 ½s¿è
¦^´_ 1# momo020608
°w¹ï¤W¤U¤¤»ù
»ù°Ï
¶q°Ï
¤W = percentile(»ù°Ï,0.8)
¤U = percentile(»ù°Ï,0.2)
¤W¡B¤U¡B¤¤»ù
sumproduct((»ù°Ï>¤W)*»ù°Ï*¶q°Ï)/sumif(»ù°Ï,">"&¤W,¶q°Ï)
sumproduct((»ù°Ï<¤U)*»ù°Ï*¶q°Ï)/sumif(»ù°Ï,"<"&¤U,¶q°Ï)
sumproduct(((»ù°Ï<¤W)*(»ù°Ï>¤U))*»ù°Ï*¶q°Ï)/sumifs(¶q°Ï,»ù°Ï,"<"&¤W,»ù°Ï">"&¤U) |
|