- Picture and text skills
- Case
Returns the harmonic mean of the data collection. The harmonic mean and the reciprocal arithmetic mean are reciprocals of each other.
Syntax
HARMEAN(number1,number2,...)
Number1, number2, ... 1 to 30 parameters that can be used to calculate the average, or instead of comma-separated parameters, use a single
In the form of an array or array reference.
Description
• The argument can be a number, or a name, array, or reference containing a number.
• If the array or reference parameter contains text, logical values, or blank cells, those values are ignored; however, cells containing zero values are counted.
• If any data point is less than or equal to 0, function HARMEAN returns the #NUM! error value.
• The harmonic mean is always less than the geometric mean, and the geometric mean is always less than the arithmetic mean.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/HARMEAN-han-shu-qiu-tiao-he-ping-jun-zhi.html
评论列表(196条)
测试