公式1:=TRIMMEAN(B3:B56,ROUND(COUNT(B3:B56)*0.2,)*2/COUNT(B3:B56))
公式2:=(SUM(B3:B57)-SUM((LARGE(B3:B57,{1,2})+SMALL(B3:B57,{1,2}))/{1,2}))/(COUNT(B3:B57)-3)
公式3:=TRIMMEAN(B3:B57,2/COUNT(B3:B57))
公式4:=AVERAGE(B3:B57)
整合起来
=CHOOSE(MATCH(COUNT(B3:B57),{3,5,7,10}),AVERAGE(B3:B57),TRIMMEAN(B3:B57,2/COUNT(B3:B57)),(SUM(B3:B57)-SUM((LARGE(B3:B57,{1,2})+SMALL(B3:B57,{1,2}))/{1,2}))/(COUNT(B3:B57)-3),TRIMMEAN(B3:B56,ROUND(COUNT(B3:B56)*0.2,)*2/COUNT(B3:B56)))
应该是这个意思
|