Formulas and Functions

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
HARMEAN
The HARMEAN function returns the harmonic mean.
HARMEAN(pos-num, pos-num…)
 pos-num: A positive number. a-pos-num is a number value and must be greater
than 0.
 pos-num…:Optionally include one or more additional positive numbers.
Usage Notes
The harmonic mean is the reciprocal of the arithmetic mean of the reciprocals. Â
Example
=HARMEAN(5, 7, 3, 2, 6, 22) returns 4.32179607109448.
Related Topics
For related functions and additional information, see:
“AVERAGE” on page 231
“GEOMEAN” on page 261
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
INTERCEPT
The INTERCEPT function returns the y-intercept of the best-t line for the collection
using linear regression analysis.
INTERCEPT(y-values, x-numbers)
 y-values: The collection containing the y (dependent) values. y-values is a collection
that can contain number, date/time, or duration values. All values must be of the
same type.
262 Chapter 10 Statistical Functions