Download PlanMaker 2006 User Guide

Note:
Unlike the STDEVP function, STDEVPA also evaluates logical values
and text:
FALSE evaluates as 0.
TRUE evaluates as 1.
Text evaluates as 0.
Annotation:
The standard deviation is calculated using the "biased" or "n" method.
Example:
STDEVPA(2, 2, 3, 4, 1) returns 1.0198
See also:
STDEVP
STEYX (standard error of a linear regression)
Syntax:
STEYX(y_values, x_values)
Description:
Returns the standard error of a linear regression.
y_values are the known y values.
x_values are the known x values.
Example:
The resistance of a temperature-sensitive resistor has been measured at
several temperatures.
Cells A1:A4 contain the temperatures measured: 8, 20, 25, 28
Cells B1:B4 contain the resistances measured: 261, 508, 608, 680
The following calculation returns the standard error of the resistances
predicted by linear regression:
STEYX(B1:B4, A1:A4) returns 4.97351
See also:
INTERCEPT, SLOPE, FORECAST
SUBSTITUTE (replace text in a text string)
Syntax:
SUBSTITUTE(Text, OldText, NewText [, n])
Description:
Searches for OldText in a text string. If found, OldText will be replaced by NewText.
Text is the text string in which you want to replace text.
416 • Formulas and functions
User Manual PlanMaker