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