North
__________ Rounds a number
up, to the nearest integer or the nearest multiple of
significance.
__________ Returns
the harmonic mean of a data set. The harmonic mean is the
reciprocal of the arithmetic mean of reciprocals.
__________ Multiplies the values in a column
of a list or database that match conditions you specify.
__________ Returns a reference to a range
that is a specified number of rows and columns from a cell or range
of cells. The reference that is returned can be a single cell or a
range of cells. You can specify the number of rows and the number
of columns to be returned.
__________ Check whether a value is a logical
value (TRUE or FALSE), and returns TRUE or FALSE,
__________ Calculates the point at which a
line will intersect the y-axis by using existing x-values and
y-values. The intercept point is based on a best-fit regression
line plotted through the known x-values and known
y-values.
__________ Returns the average of the
absolute deviations of data points from their mean. It is a measure
of the variability in a data set.
West
__________ Returns
the average (arithmetic mean) of the arguments.
__________ Returns the individual term
binomial distribution probability.
__________ Calculates the average (arithmetic
mean) of the values in the list of arguments. In addition to
numbers, text and logical values such as TRUE and FALSE are
included in the calculation.
__________ Returns number
rounded up to the nearest odd integer.
__________ Returns the
hypergeometric distribution.
__________ Looks for a
value in the top row of a table or array of values and returns the
value in the same column from a row you specify.
__________ Returns the depreciation of an
asset for a specified period using the fixed-declining balance
method.
__________ Returns the
exponential distribution.
|