Microsoft Office Tutorials and References
In Depth Information
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
STDEVPA calculates standard deviation based on the entire population given as arguments.
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.
STEYX returns the standard error of the predicted y value for each x in the regression.
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.
Is the set of independent data points.
The equation for the STEYX is