ÄÏËεÚÒ»ÎÔµ×2¡¢¿ì½Ý¼ü£ºCtrl+\£¨·´Ð±¸Ü£©¡£3¡¢Ìî³ä»ò±ê×¢ÑÕÉ«¡£¿ìÖØÉúÆéá«Áʵ¹Å©´åϱËÙΪѡÊÖ´ò·ÖÒªÁ죺1¡¢Ñ¡¶¨Ä¿µÄµ¥Î»¸ñ¼¤ÇéÎÄѧ8888¡£2¡¢ÊäÈ빫ʽ£º=TRIMMEAN(B3:K3,2/10)¡£3¡¢Ctrl+EnterÌî³ä¡£½â¶Á£º¹«Ê½£º=TRIMMEAN(B3:K3,2/10)ÖеÄ2λȥµôÒ»¸ö×î¸ß·ÖºÍÒ»¸ö×îµÍ·Ö£¬10ΪÆÀίµÄÈËÊý¡£
µ±Ô£¬ÒÑ(y¨«)¿ª(k¨¡i)¹¤½¨(ji¨¤n)Éè341¸öÏîÄ¿(m¨´)£»ÒÑ¿¢(j¨´n)¹¤(g¨ng)52¸öÏî(xi¨¤ng)Ä¿(m¨´)¡£Ç°5¸öÔÂÈ«Ê¡ÖØµãÏîÄ¿(m¨´)Íê³ÉͶ×ʽø¶È½ÏºÃ£¬¿ì(ku¨¤i)ÓÚÐò(x¨´)ʱ½ø¶È4.2¸ö°Ù·Öµã£»Ïî(xi¨¤ng)Ä¿¿ª¹¤³ÌÐò¼ÓËÙ£¬¿ª¹¤ÂÊ¿ìÓÚ(y¨²)Ðòʱ½ø¶È(d¨´)15.2¸ö(g¨¨)°Ù·Öµã(di¨£n)¡£Ê¡Öصã°ìÏà¹ØÈÏÕæ(z¨¦)ÈËÌåÏÖ£¬¸÷µØ¸÷²¿·Ö½«ÉîÈë¹á³¹Âäʵ(sh¨ª)È«(qu¨¢n)ʡʵÑé(sh¨©)¡°Îå´ó(d¨¤)·¢(f¨¡)Õ¹ÐÐÅ©´å(c¨±n)ÕâÒ°²ËÊǸö±¦£¬ÌìÌì³ÔÒ»µã£¬¿¹²¡¶¾¡¢Ô¤·À¸ß(g¨¡o)ѪѹºÍÉñ¾ÐéÈõ»ð̿ĸµÄ¹¦Ð§1¡¢¿¹¾ú¿¹¾úÊÇ(sh¨¬)»ð(hu¨¯)̿ĸÈëÒ©ÒÔºóµÄÖ÷Òª¹¦Ð§Ö®Ò»£¬Æ½Ê±(sh¨ª)°ÑËü¼ÓÇåË®¼å(ji¨¡n)ÖÆÒÔ(y¨«)ºó£¬»ñµÃµÄÒ©Òº£¬¶ÔÈËÌåÄڵĽð(j¨©n)»ÆÉ«ÆÏÌÑÇò¾úºÍ(h¨¦)´ó³¦¸Ë(g¨¡n)¾ú£¬ÒÔ¼°ÂÃÐÐÁ´Çò¾ú£¬ÉÐÓа׺í¸Ë(g¨¡n)¾úµÈ¶àÖÖÖ²¡¾ú(j¨±n)£¬¶¼ÓÐÏÔ×ÅÒÖÖÆºÍÏû³ý(ch¨²)×÷Óã¬Äܼõ(ji¨£n)ÉÙËüÃǶÔÈËÌå(t¨«)×é֯ϸ°ûµÄΣÏÕ(h¨¤i)£¬Ò²ÄÜ(n¨¦ng)Ô¤·À(f¨¢ng)¶àÖÖ(zh¨¯ng)Ñ×Ö¢±¬·¢(sh¨¥ng)¡£¶¯(d¨°ng)ÍýÏ롱ô߸ßÖÊÁ¿(li¨¤ng)ÍÆ½ø(j¨¬n)ÏîÄ¿(m¨´)½¨ÉèÊÓ(sh¨¬)Ƶ(p¨ªn)½»Á÷µ÷Àí»á¾«Éñ£¬Æ¾Ö¤¡°ÒÔ