Äîêóìåíò âçÿò èç êýøà ïîèñêîâîé ìàøèíû. Àäðåñ îðèãèíàëüíîãî äîêóìåíòà : 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
Prev		Next

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.

Prev	Home	Next
TRIM	Up	TRUE