. : http://uneex.lorien.cs.msu.su/static/GnumericDoc_ru/r8994.html
: Mon Sep 26 12:35:55 2011
: Tue Oct 2 08:10:56 2012
: IBM-866

:
TRIMMEAN

TRIMMEAN

Name

TRIMMEAN -- 

Synopsis

TRIMMEAN(ref,percent)

Description

ɺ̺ TRIMMEAN Ǻغú ö¶ɶö ɺѺöɶɶö ӺѶ ɺǺ ºɶɺں. @ref - ʶ̺Ǻ Ӷ̺ö, ¶Ⱥ ǺѶǺǶ ʺǶǶº޺Ѻ ںӶ̺ȶöɶ̺, @percent - ʺǺöɺ ǺѶڶöͺں Ӷ̺ö. 뺃ʺ̶Ͷú, úȶ @percent=0.2 ɺǺ ºɶɺں Ƕ¶ú̺ 40 Ӷ̺ö, ̺ ɺǺ ºɶɺں º ڶǺöɺ 8 Ӷ̺ö (40x0.2), ʶ 4 ǶǶ̺ ǶɺǶ ɺǺ.

Ѻ Ժɺ̺ ǶͶúѶ̶ͺ Excel.

Examples

ǶʺѶ̶, ӺѶ ޺Ӷö˺ A1,A2...A5 Ƕ¶ú Ӷ̺Ⱥ 11.4, 17.3, 21.3, 25.9 40.1. Ƕº

TRIMMEAN(A1:A5,0.2) ɺ޶úѺ 23.2.

See also

AVERAGE, GEOMEAN, HARMEAN, MEDIAN, MODE.