Microsoft Office Tutorials and References

In Depth Information

**DEVSQ**

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.

TRIALS

Is the probability of success on each trial; must be a positive number

less than 1.

PROBABILITY_S

Is the criterion value that the cumulative binomial distribution must

be below.

ALPHA

Figure 11.12

Increasing the

probability while keeping

the alpha unchanged

has no impact on the

CRITBINOM
function

result.

DEVSQ

DEVSQ
returns the sum of squares of deviations of a data set from their sample mean.

=DEVSQ(number1,number2,...)

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.

NUMBER N

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.