- Picture and text skills
- Case
Returns the harmonic mean of a data collection. The harmonic mean and the reciprocal arithmetic mean are reciprocals of each other.
SyntaxHARMEAN(number1,number2,...)
Number1, number2, ... can be used to calculate the average of 1 to 30 arguments, or instead of commas separating arguments, use a single array or array reference.
Description
- Parameters can be numbers, or names, arrays, or references containing numbers.
- If the array or reference parameter contains text, logical values, or blank cells, these values will be ignored; however, cells containing zero values will be counted.
- If any data point is less than or equal to 0, function HARMEAN returns the error value #NUM!.
- 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/tan-suo-HARMEAN-han-shu-ji-suan-tiao-he-ping-jun-zhi-de-jian-bian-fang-fa.html
支付宝扫一扫 
评论列表（196条）
测试