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
Search JabSto ::




Custom Search