Microsoft Office Tutorials and References

In Depth Information

**STDEVPA**

Figure 11.47

Use the
STDEVP

function when the data set

is the entire

population. If your data set is

a sample of the

population, use the
STDEV

function.

STDEVPA

STDEVPA
calculates standard deviation based on the entire population given as arguments.

=STDEVPA(value1,value2,...)

The
STDEVPA
function differs from the
STDEVP
function in that it will also evaluate logical

values such as TRUE and FALSE. TRUE evaluates to one (1); FALSE evaluates to zero (0).

Arguments that contain text also evaluate to zero. Refer to Figure 11.47 for a comparison of

STDEVP
and
STDEVPA
.

Is the cell reference(s), range name, text representations of numbers,

array, or logical values that makes up the data set. Up to 30 arguments

(unique data sets) can be specified.

VALUE N

STEYX

STEYX
returns the standard error of the predicted y value for each x in the regression.

=STEYX(known_y’s,known_x’s)

The
STEYX
function is a measure of the amount of error in the prediction of y for an individual x.

Figure 11.48 shows an example of the standard error that can be expected for the sales figures.

Is the set of data points or values; the dependent variable.

KNOWN_Y’S

Is the set of independent data points.

KNOWN_X’S

The equation for the
STEYX
is