Difference between revisions of "Documentation/How Tos/Calc: HARMEAN function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
Line 1: Line 1:
−
{{Documentation/MasterTOC
+
{{DISPLAYTITLE:HARMEAN function}}
−
|bookid=1234'''
+
{{Documentation/CalcFunc StatisticalTOC
−
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
+
|ShowPrevNext=block
−
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Statistical_functions|<div style="font-size: 140%;">Statistical Functions]]
+
|PrevPage=Documentation/How_Tos/Calc:_GEOMEAN_function
−
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_MEDIAN_function
+
|NextPage=Documentation/How_Tos/Calc:_MEDIAN_function
−
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_GEOMEAN_function
+
}}__NOTOC__
−
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Spreadsheet_functions
+
−
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Text_functions
+
−
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Measures of Central Tendency</div>
+
−
* [[Documentation/How_Tos/Calc:_AVEDEV_function|<div style="font-size: 120%;">Avedev]]
+
−
* [[Documentation/How_Tos/Calc:_AVERAGE_function|<div style="font-size: 120%;">Average]]
+
−
* [[Documentation/How_Tos/Calc:_AVERAGEA_function|<div style="font-size: 120%;">Averagea]]
+
−
* [[Documentation/How_Tos/Calc:_COUNT_function|<div style="font-size: 120%;">Count]]
+
−
* [[Documentation/How_Tos/Calc:_COUNTA_function|<div style="font-size: 120%;">Counta]]
+
−
* [[Documentation/How_Tos/Calc:_GEOMEAN_function|<div style="font-size: 120%;">Geomean]]
+
−
* [[Documentation/How_Tos/Calc:_HARMEAN_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Hearmean]]
+
−
* [[Documentation/How_Tos/Calc:_MEDIAN_function|<div style="font-size: 120%;">Median]]
+
−
* [[Documentation/How_Tos/Calc:_MODE_function|<div style="font-size: 120%;">Mode]]
+
−
* [[Documentation/How_Tos/Calc:_TRIMMEAN_function|<div style="font-size: 120%;">Trimmean]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Measures of dispersion / spread</div>
+
−
* [[Documentation/How_Tos/Calc:_DEVSQ_function|<div style="font-size: 120%;">Devsq]]
+
−
* [[Documentation/How_Tos/Calc:_KURT_function|<div style="font-size: 120%;">Kurt]]
+
−
* [[Documentation/How_Tos/Calc:_SKEW_function|<div style="font-size: 120%;">Skew]]
+
−
* [[Documentation/How_Tos/Calc:_STDEV_function|<div style="font-size: 120%;">Stdev]]
+
−
* [[Documentation/How_Tos/Calc:_STDEVA_function|<div style="font-size: 120%;">Stedeva]]
+
−
* [[Documentation/How_Tos/Calc:_STDEVP_function|<div style="font-size: 120%;">Stdevp]]
+
−
* [[Documentation/How_Tos/Calc:_STDEVPA_function|<div style="font-size: 120%;">Stdevpa]]
+
−
* [[Documentation/How_Tos/Calc:_VAR_function|<div style="font-size: 120%;">Var]]
+
−
* [[Documentation/How_Tos/Calc:_VARA_function|<div style="font-size: 120%;">Vara]]
+
−
* [[Documentation/How_Tos/Calc:_VARP_function|<div style="font-size: 120%;">Varp]]
+
−
* [[Documentation/How_Tos/Calc:_VARPA_function|<div style="font-size: 120%;">Varpa]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Probability and statistics</div>
+
−
* [[Documentation/How_Tos/Calc:_B_function|<div style="font-size: 120%;">B]]
+
−
* [[Documentation/How_Tos/Calc:_BETADIST_function|<div style="font-size: 120%;">Betadist]]
+
−
* [[Documentation/How_Tos/Calc:_BETAINV_function|<div style="font-size: 120%;">Betainv]]
+
−
* [[Documentation/How_Tos/Calc:_BINOMDIST_function|<div style="font-size: 120%;">Binomdist]]
+
−
* [[Documentation/How_Tos/Calc:_CHIDIST_function|<div style="font-size: 120%;">Chidist]]
+
−
* [[Documentation/How_Tos/Calc:_CHIINV_function|<div style="font-size: 120%;">Chinv]]
+
−
* [[Documentation/How_Tos/Calc:_CHISQINV_function|<div style="font-size: 120%;">Chisqinv]]
+
−
* [[Documentation/How_Tos/Calc:_CHITEST_function|<div style="font-size: 120%;">Chitest]]
+
−
* [[Documentation/How_Tos/Calc:_CONFIDENCE_function|<div style="font-size: 120%;">Confidence]]
+
−
* [[Documentation/How_Tos/Calc:_CRITBINOM_function|<div style="font-size: 120%;">Critbinom]]
+
−
* [[Documentation/How_Tos/Calc:_EXPONDIST_function|<div style="font-size: 120%;">Expondist]]
+
−
* [[Documentation/How_Tos/Calc:_FINV_function|<div style="font-size: 120%;">Finv]]
+
−
* [[Documentation/How_Tos/Calc:_FISHER_function|<div style="font-size: 120%;">Fisher]]
+
−
* [[Documentation/How_Tos/Calc:_FISHERINV_function|<div style="font-size: 120%;">Fisherinv]]
+
−
* [[Documentation/How_Tos/Calc:_FDIST_function|<div style="font-size: 120%;">Fdist]]
+
−
* [[Documentation/How_Tos/Calc:_FTEST_function|<div style="font-size: 120%;">Ftest]]
+
−
* [[Documentation/How_Tos/Calc:_GAMMA_function|<div style="font-size: 120%;">Gamma]]
+
−
* [[Documentation/How_Tos/Calc:_GAMMAINV_function|<div style="font-size: 120%;">Gammainv]]
+
−
* [[Documentation/How_Tos/Calc:_GAMMALN_function|<div style="font-size: 120%;">Gammaln]]
+
−
* [[Documentation/How_Tos/Calc:_GAMMADIST_function|<div style="font-size: 120%;">Gammadist]]
+
−
* [[Documentation/How_Tos/Calc:_GAUSS_function|<div style="font-size: 120%;">Gauss]]
+
−
* [[Documentation/How_Tos/Calc:_HYPGEOMDIST_function|<div style="font-size: 120%;">Hypgeomdist]]
+
−
* [[Documentation/How_Tos/Calc:_LOGINV_function|<div style="font-size: 120%;">Loginv]]
+
−
* [[Documentation/How_Tos/Calc:_LOGNORMDIST_function|<div style="font-size: 120%;">Lognormdist]]
+
−
* [[Documentation/How_Tos/Calc:_NEGBINOMDIST_function|<div style="font-size: 120%;">Negbinomdist]]
+
−
* [[Documentation/How_Tos/Calc:_NORMINV_function|<div style="font-size: 120%;">Norminv]]
+
−
* [[Documentation/How_Tos/Calc:_NORMDIST_function|<div style="font-size: 120%;">Normdist]]
+
−
* [[Documentation/How_Tos/Calc:_NORMSINV_function|<div style="font-size: 120%;">Normsinv]]
+
−
* [[Documentation/How_Tos/Calc:_NORMSDIST_function|<div style="font-size: 120%;">Normsdist]]
+
−
* [[Documentation/How_Tos/Calc:_PERMUT_function|<div style="font-size: 120%;">Permut]]
+
−
* [[Documentation/How_Tos/Calc:_PERMUTATIONA_function|<div style="font-size: 120%;">Permutationa]]
+
−
* [[Documentation/How_Tos/Calc:_PHI_function|<div style="font-size: 120%;">Phi]]
+
−
* [[Documentation/How_Tos/Calc:_POISSON_function|<div style="font-size: 120%;">Poisson]]
+
−
* [[Documentation/How_Tos/Calc:_PROB_function|<div style="font-size: 120%;">Prob]]
+
−
* [[Documentation/How_Tos/Calc:_STANDARDIZE_function|<div style="font-size: 120%;">Standardize]]
+
−
* [[Documentation/How_Tos/Calc:_TDIST_function|<div style="font-size: 120%;">Tdist]]
+
−
* [[Documentation/How_Tos/Calc:_TINV_function|<div style="font-size: 120%;">Tinv]]
+
−
* [[Documentation/How_Tos/Calc:_TTEST_function|<div style="font-size: 120%;">Ttest]]
+
−
* [[Documentation/How_Tos/Calc:_WEIBULL_function|<div style="font-size: 120%;">Weibull]]
+
−
* [[Documentation/How_Tos/Calc:_ZTEST_function|<div style="font-size: 120%;">Ztest]]
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Correlation and line fitting</div>
+
−
* [[Documentation/How_Tos/Calc:_CORREL_function|<div style="font-size: 120%;">Correl]]
+
−
* [[Documentation/How_Tos/Calc:_COVAR_function|<div style="font-size: 120%;">Covar]]
+
−
* [[Documentation/How_Tos/Calc:_FORECAST_function|<div style="font-size: 120%;">Forecast]]
+
−
* [[Documentation/How_Tos/Calc:_INTERCEPT_function|<div style="font-size: 120%;">Intercept]]
+
−
* [[Documentation/How_Tos/Calc:_PEARSON_function|<div style="font-size: 120%;">Pearson]]
+
−
* [[Documentation/How_Tos/Calc:_RSQ_function|<div style="font-size: 120%;">Rsq]]
+
−
* [[Documentation/How_Tos/Calc:_SLOPE_function|<div style="font-size: 120%;">Slope]]
+
−
* [[Documentation/How_Tos/Calc:_STEYX_function|<div style="font-size: 120%;">Steyx]]
+
−
<div style="font-size: 110%;">''See also (in the [[Documentation/How_Tos/Calc:_Array_functions|Array Function]] category); GROWTH, LINEST, LOGEST, TREND''</div>
+
−
 
+
−
<div style="font-size: 140%; border-style: outset outset outset none; border-color:#DCE9FC;">Ranking</div>
+
−
* [[Documentation/How_Tos/Calc:_LARGE_function|<div style="font-size: 120%;">Large]]
+
−
* [[Documentation/How_Tos/Calc:_MAX_function|<div style="font-size: 120%;">Max]]
+
−
* [[Documentation/How_Tos/Calc:_MAXA_function|<div style="font-size: 120%;">Maxa]]
+
−
* [[Documentation/How_Tos/Calc:_MIN_function|<div style="font-size: 120%;">Min]]
+
−
* [[Documentation/How_Tos/Calc:_MINA_function|<div style="font-size: 120%;">Mina]]
+
−
* [[Documentation/How_Tos/Calc:_PERCENTILE_function|<div style="font-size: 120%;">Percentile]]
+
−
* [[Documentation/How_Tos/Calc:_PERCENTRANK_function|<div style="font-size: 120%;">Percentrank]]
+
−
* [[Documentation/How_Tos/Calc:_QUARTILE_function|<div style="font-size: 120%;">Quartile]]
+
−
* [[Documentation/How_Tos/Calc:_RANK_function|<div style="font-size: 120%;">Rank]]
+
−
* [[Documentation/How_Tos/Calc:_SMALL_function|<div style="font-size: 120%;">Small]]
+
−
}}__TOC__
+
  
 
== HARMEAN ==
 
== HARMEAN ==

Latest revision as of 13:24, 2 February 2024



HARMEAN

Returns the harmonic mean of the arguments.

Syntax:

HARMEAN(number1; number2; ... number30)

number1 to number30 are up to 30 numbers or ranges containing numbers. Numbers must not be zero.
The harmonic mean of a1, a2, ... an is defined as
Calc harmean formula.png.

Example:

HARMEAN(2; 4; 4)

returns 3, calculated as 3/(1/2 + 1/4 + 1/4).

Issues:

  • Calc assumes that logical values are 1 (TRUE) and 0 (FALSE). Excel ignores logical values.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_HARMEAN_function&oldid=260017"
Views
Personal tools
Navigation
Tools