Difference between revisions of "Manuals/calci/HARMEAN"
Jump to navigation
Jump to search
| Line 12: | Line 12: | ||
ie | ie | ||
:<math> H=\frac{n}{\sum_{i=1}^{n} \frac{1}{xi}}</math>. | :<math> H=\frac{n}{\sum_{i=1}^{n} \frac{1}{xi}}</math>. | ||
| − | *In HARMEAN(n_1,n_2,...) | + | *In <math>HARMEAN(n_1,n_2,...), n_1,n_2..</math> are the positive real numbers, and here <math>n_1</math> is required. <math>n_2,n_3...</math>, are optional. |
*Also arguments can be numbers,names, arrays or references that contain numbers. | *Also arguments can be numbers,names, arrays or references that contain numbers. | ||
*We can give logical values and text representations of numbers directly. | *We can give logical values and text representations of numbers directly. | ||
Revision as of 14:31, 8 May 2015
HARMEAN(n1,n2,...)
- are the positive real numbers.
are the positive real numbers.Description
- This function gives the Harmonic Mean of a given set of numbers.
- Harmonic mean is used to calculate the average of a set of numbers.
- The Harmonic mean is always the lowest mean.
- Normally
- Harmonic mean is defined as the reciprocal of the arithmetic mean by the reciprocals of a specified set of numbers.
- The harmonic mean of a positive real numbers is defined by :
is defined by :ie
ie
- .
.- In are the positive real numbers, and here is required. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n_2,n_3...} , are optional.
- Also arguments can be numbers,names, arrays or references that contain numbers.
- We can give logical values and text representations of numbers directly.
- Suppose the arguments contains any text, logical values or empty cells like that values are ignored.
- This will give the result as error when
are the positive real numbers, and here 
is required. Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n_2,n_3...}
, are optional.1.The arguments with the error values or the referred text couldn't translated in to numbers.
2.Also any data Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle point \le 0}
.
ZOS Section
- The syntax is to calculate HARMEAN in ZOS is Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle HARMEAN(n_1,n_2,....)}
.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n_1,n_2,...} are the positive real numbers.
- For e.g.,HARMEAN(20..30,11..15,45.1..56.1..0.5)
Examples
- =HARMEAN(1,2,3,4,5) = 2.18978102189781
- =HARMEAN(20,25,32,41) = 27.4649361523969
- =HARMEAN(0.25,5.4,3.7,10.1,15.2) = 1.0821913906985883
- =HARMEAN(3,5,0,2) = #ERROR
- =HARMEAN(1,-2,4) = #ERROR