{"id":2929,"date":"2022-04-04T21:18:08","date_gmt":"2022-04-04T13:18:08","guid":{"rendered":"https:\/\/emt.bjtu.edu.cn\/cn\/?p=2929"},"modified":"2023-09-24T21:52:13","modified_gmt":"2023-09-24T13:52:13","slug":"trimmean","status":"publish","type":"post","link":"https:\/\/emt.bjtu.edu.cn\/cn\/trimmean\/","title":{"rendered":"EXCEL\u8bc4\u5206\u51fd\u6570 TRIMMEAN"},"content":{"rendered":"\n<p>\u8bc4\u5206\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u4f7f\u7528EXCEL\u81ea\u5e26\u7684 TRIMMEAN \u51fd\u6570\u3002<\/p>\n\n\n\n<p>\u6700\u5e38\u7528\u7684\u8bc4\u5206\u89c4\u5219\u662f\uff1a\u53bb\u6389\u6700\u9ad8\u5206\u548c\u6700\u4f4e\u5206\uff0c\u5176\u4ed6\u6210\u7ee9\u53d6\u5e73\u5747\u3002\u8fd9\u662f\u6700\u5e38\u7528\u7684\u8bc4\u5206\u8ba1\u7b97\u65b9\u6cd5\uff0c\u5965\u8fd0\u4f1a\u591a\u4e2a\u9879\u76ee\u4f7f\u7528\u3002<\/p>\n\n\n\n<p>\u6700\u5e38\u60f3\u5230\u7684\u5b9e\u73b0\u65b9\u6cd5\u662f\u5148\u6c42\u548c\u518d\u51cf\u53bb\u6700\u9ad8\u5206\u548c\u6700\u4f4e\u5206\uff0c\u7136\u540e\u9664\u4ee5\u8bc4\u59d4\u6570\u51cf2\uff0c\u516c\u5f0f\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>=(sum(B2:G2)-MAX(B2:G2)-MIN(B2:G2))\/(COUNT(B2:G2)-2)<\/p>\n\n\n\n<p>\u8fd9\u4e2a\u516c\u5f0f\u5f88\u7e41\u7410\uff0cEXCEL\u81ea\u5e26\u7684TRIMMEAN\u53ea\u9700\u4e00\u53e5\uff0c\u8ba1\u7b97\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p><strong>=TRIMMEAN(B2:G2,2\/6)<\/strong><\/p>\n\n\n\n<p>\u793a\u4f8bExcel\u6587\u4ef6\u5982\u4e0b\uff0c\u53ef\u76f4\u63a5\u4e0b\u8f7d\u4f7f\u7528\uff1a<\/p>\n\n\n<a  data-e-Disable-Page-Transition=\"true\" class=\"download-link\" title=\"\u7248\u672c v1.0\" href=\"https:\/\/emt.bjtu.edu.cn\/cn\/download\/2931\/?tmstv=1776865737\" rel=\"nofollow\" id=\"download-link-2931\" data-redirect=\"false\" >\n\tTrimMean Example\t(\u4e0b\u8f7d15941\t)\n<\/a>\n\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">TRIMMEAN\u8bf4\u660e<\/h2>\n\n\n\n<p>\u8fd4\u56de\u6570\u636e\u96c6\u7684\u5185\u90e8\u5e73\u5747\u503c\u3002 TRIMMEAN \u8ba1\u7b97\u6392\u9664\u6570\u636e\u96c6\u9876\u90e8\u548c\u5e95\u90e8\u5c3e\u6570\u4e2d\u6570\u636e\u70b9\u7684\u767e\u5206\u6bd4\u540e\u53d6\u5f97\u7684\u5e73\u5747\u503c\u3002 \u5f53\u60a8\u8981\u4ece\u5206\u6790\u4e2d\u6392\u9664\u65e0\u5173\u7684\u6570\u636e\u65f6\uff0c\u53ef\u4ee5\u4f7f\u7528\u6b64\u51fd\u6570\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">TRIMMEAN\u8bed\u6cd5<\/h2>\n\n\n\n<p>TRIMMEAN(array, percent)<\/p>\n\n\n\n<p>TRIMMEAN \u51fd\u6570\u8bed\u6cd5\u5177\u6709\u4e0b\u5217\u53c2\u6570\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Array<\/strong>&nbsp;&nbsp;&nbsp;&nbsp;\u5fc5\u9700\u3002 \u9700\u8981\u8fdb\u884c\u6574\u7406\u5e76\u6c42\u5e73\u5747\u503c\u7684\u6570\u7ec4\u6216\u6570\u503c\u533a\u57df\u3002<\/li>\n\n\n\n<li><strong>\u767e\u5206\u6bd4<\/strong>&nbsp;&nbsp;&nbsp;&nbsp;\u5fc5\u9700\u3002 \u4ece\u8ba1\u7b97\u4e2d\u6392\u9664\u6570\u636e\u70b9\u7684\u5206\u6570\u3002 \u4f8b\u5982\uff0c\u5982\u679c percent=0.2\uff0c\u4ece 20 \u70b9 (20 x 0.2) \u7684\u6570\u636e\u96c6\u4e2d\u526a\u88c1 4 \u70b9\uff1a\u6570\u636e\u96c6\u9876\u90e8\u7684 2 \u70b9\u548c\u5e95\u90e8\u7684 2 \u70b9\u3002<\/li>\n<\/ul>\n\n\n\n<p><strong>Reference\uff1a<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/support.microsoft.com\/zh-cn\/office\/trimmean-%e5%87%bd%e6%95%b0-d90c9878-a119-4746-88fa-63d988f511d3?ocmsassetid=hp010342968&amp;correlationid=262e670c-db67-46d2-a38b-a598306c33b0&amp;ui=zh-cn&amp;rs=zh-cn&amp;ad=cn\">Microsoft Office TrimMean Function<\/a>  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8bc4\u5206\u5f88\u7b80\u5355\uff0c\u53ea\u9700\u4f7f\u7528EXCEL\u81ea\u5e26\u7684 TRIMMEAN \u51fd\u6570\u3002<\/p>\n<p>\u6700\u5e38\u7528\u7684\u8bc4\u5206\u89c4\u5219\u662f\uff1a\u53bb\u6389\u6700\u9ad8\u5206\u548c\u6700\u4f4e\u5206\uff0c\u5176\u4ed6\u6210\u7ee9\u53d6\u5e73\u5747\u3002\u8fd9\u662f\u6700\u5e38\u7528\u7684\u8bc4\u5206\u8ba1\u7b97\u65b9\u6cd5\uff0c\u5965\u8fd0\u4f1a\u591a\u4e2a\u9879\u76ee\u4f7f\u7528\u3002<\/p>\n","protected":false},"author":1,"featured_media":3156,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"on","neve_meta_content_width":100,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"[\"title\",\"meta\",\"thumbnail\",\"content\",\"tags\",\"comments\",\"post-navigation\"]","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-2929","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/posts\/2929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/comments?post=2929"}],"version-history":[{"count":9,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/posts\/2929\/revisions"}],"predecessor-version":[{"id":4164,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/posts\/2929\/revisions\/4164"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/media\/3156"}],"wp:attachment":[{"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/media?parent=2929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/categories?post=2929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/tags?post=2929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}