ä¾:
A B
1 æ绩 å»ææé«ååæä½ååçå¹³åå
2 9 =
3 8.5
4 8.5
5 9.5
å»ææé«ååæä½ååçå¹³ååï¼å¦æè¦ä¿ç1ä½å°æ°ï¼å
=ROUND((SUM(A2:A10)-MAX(A2:A10)-MIN(A2:A10))/(COUNTA(A2:A10)-2),1)
è¿éæä¾ä¸ç§æ¹æ³ã
1ãtrimmean(a1:a10,0.2)
a1:a10æ¯è¦ç»è®¡çæ°æ®èå´ï¼0.2æ¯å°±æ¯20%ã
TRIMMEANå½æ°å¯ä»¥æ±å¾æªå»é¨åæå¼åçæ°æ®çå¹³åå¼ï¼å³TRIMMEANå
ä»æ°æ®éç头é¨åå°¾é¨é¤å»ä¸å®ç¾åæ¯çæ°æ®ï¼ç¶ååæ±å¹³åå¼ãèä¸é¢å
¬å¼ä¸çâ0.2âï¼å³æ们æè§å®çè¦å»é¤æ°æ®çç¾åæ¯ã
éè¦æ³¨æçæ¯å½æ°TRIMMEANå°é¤å»çæ°æ®æ°ç®åä¸èå
¥ä¸ºææ¥è¿ç2çåæ°ãå¦å
±æ19个æ°æ®ï¼å»é¤ç¾åæ¯ä¸º0.2ï¼å19ç20%为3.8ï¼åä¸èå
¥ææ¥è¿ç2çåæ°ä¸º2ï¼æ£å¥½å¯¹ç§°å°å¨æ°æ®éç头é¨åå°¾é¨åé¤å»ä¸ä¸ªæ°æ®ã
æ以ï¼ç¨æ¤å½æ°ï¼å
¬å¼ç®åï¼ä½å¨ç¾åæ¯çéæ©ä¸åºè¯¥å°å¿è°¨æ
ï¼ä»¥å
产ç计ç®é误ã
2ãSUM(LARGE(A1:A10,ROW(INDIRECT("1:1"))))åSUM(SMALL(A1:A10,ROW(INDIRECT("1:1"))))
è¿ä¸¤ä¸ªå½æ°æ¯æ°ç»å½æ°ï¼æ±åºçæ¯ä¸åæ°ä¸çä¸ä¸ªæå 个æ大å¼åæå°å¼ï¼è¾å
¥å®æååºæCTRLåSHIFTé®çåæ¶æå车ã
a1:a10æ¯è¦ç»è®¡çæ°æ®èå´ï¼1ï¼1表示ä¸ä¸ªæ大å¼ææå°å¼ï¼1ï¼2表示äºä¸ªæ大å¼ææå°å¼ï¼ä»¥æ¤ç±»æ¨ã
3ãSUM(LARGE(A1:A10,{1,2,3}))åSUM(SMALL(A1:A10,{1,2,3}))
è¿ä¸¤ä¸ªå½æ°æ±åºçæ¯ä¸åæ°ä¸çä¸ä¸ªæå 个æ大å¼åæå°å¼ã
a1:a10æ¯è¦ç»è®¡çæ°æ®èå´ï¼{1}表示ä¸ä¸ªæ大å¼ææå°å¼ï¼{1ï¼2}表示äºä¸ªæ大å¼ææå°å¼ï¼ä»¥æ¤ç±»æ¨ã
第äºå第ä¸ç§æ¹æ³å¨æ±åºä¸ä¸ªï¼æå 个ï¼æ大åæå°å¼åï¼ç¨æ»æ°åå»ååé¤ä»¥æ°å¼ä¸ªæ°ï¼å¯ç¨countå½æ°ï¼ï¼ç¸æ¯ä¹ä¸ç¬¬ä¸ç§æ¹æ³æç®åï¼ä½å两ç§è¾ç´è§ï¼å®¹æç解ã
温馨提示:答案为网友推荐,仅供参考