Математики дорогие и те, кто помнит статистику! Как на английском называется то, что на иврите "шахиах"? Пытаюсь найти функцию в экселе, но не помню, что искать. Функция, которая из 100, 100, 100, 200, 500, 100, 100 выдаст 100.
MODE ==== Returns the most frequently occurring, or repetitive, value in an array or range of data. Like MEDIAN, MODE is a location measure.
Syntax
MODE(number1,number2,...)
Number1, number2, ... are 1 to 30 arguments for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
branchandroot
no subject
Date: 2006-12-27 12:57 pm (UTC)no subject
Date: 2006-12-27 01:03 pm (UTC)no subject
Date: 2006-12-27 02:24 pm (UTC)no subject
Date: 2006-12-28 10:02 am (UTC)MODE
====
Returns the most frequently occurring, or repetitive, value in an array or range of data. Like MEDIAN, MODE is a location measure.
Syntax
MODE(number1,number2,...)
Number1, number2, ... are 1 to 30 arguments for which you want to calculate the mode. You can also use a single array or a reference to an array instead of arguments separated by commas.
Сорри
Date: 2006-12-28 10:07 am (UTC)