. : 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
úº ̺º Gnumeric
PrevNext

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.

PrevHomeNext
TRIMUpTRUE