Microsoft Office Tutorials and References
In Depth Information
Text Functions
Calculates standard deviation based on the entire population
given as arguments.
STDEVP
Calculates standard deviation based on the entire population
given as arguments.
STDEVPA
Returns the standard error of the predicted y-value for each x in
the regression.
STEYX
Returns the student’s t-distribution.
TDIST
Returns the inverse of the student’s t-distribution for the specified
degrees of freedom.
TINV
Returns values along a linear trend.
TREND
Returns the mean of the interior of a data set.
TRIMMEAN
Returns the probability associated with the student’s t-test.
TTEST
Estimates variance based on a sample.
VARA
Calculates variance based on the entire population.
VARP
Calculates variance based on the entire population. In addition to
numbers, text and logical values, such as TRUE and FALSE , are
included in the calculation.
VARPA
Returns the Weibull distribution.
WEIBULL
Returns the two-tailed P-value of a z-test.
ZTEST
Text Functions
CHAR
Returns the character specified by a number.
Removes all nonprintable characters from text.
CLEAN
Returns a numeric code from the first character in a text string.
CODE
Joins several text strings into one text string.
CONCATENATE
Converts a number to text using Currency format, with the
decimals rounded to the specified place.
DOLLAR
Compares two text strings and returns TRUE if they’re exactly the
same, and FALSE other wise.
EXACT
Finds one text string with another text string, and returns the
number of the starting position of find_text , from the leftmost
character of within_text .
FIND
Rounds a number to a specified number of decimals, formats the
number in decimal format using a period and commas, and
returns the result as text.
FIXED
Returns the first character or characters in a text string.
LEFT
Search JabSto ::




Custom Search