Microsoft Office Tutorials and References
In Depth Information
CRITBINOM is the probability that there are no more than a specified number of successes in
the trial. This function is frequently used for quality assurance evaluations. For example, what
is the largest number of defective products in a batch that is acceptable; more than that
number and the batch is rejected. Figure 11.12 shows an example of this function.
Is the number of trials.
Is the probability of success on each trial; must be a positive number
less than 1.
Is the criterion value that the cumulative binomial distribution must
probability while keeping
the alpha unchanged
has no impact on the
DEVSQ returns the sum of squares of deviations of a data set from their sample mean.
The sum of the deviations is always equal to zero. Squaring the deviations, then summing
them, enables you to calculate variance and standard deviation. The DEVSQ function calculates
the deviations, the square of each deviation, and mean before returning the sum of the
squares. These were included in Figure 11.13 only for illustration purposes.
You can specify up to 30 arguments for the DEVSQ function. Arguments can
be cell references, arrays, or range names. Blank cells or cells that contain
a text, or logical values are ignored. Cells containing zero (0) are included
in the calculation.