Microsoft Office Tutorials and References

In Depth Information

Calculates standard deviation based on the entire population, ignoring text

and logical values.

STDEVP

TDIST

Returns the Student's t-distribution.

TINV

Returns the inverse of the Student's t-distribution.

TTEST

Returns the probability associated with a Student's t-test.

VAR

Estimates variance based on a sample, ignoring logical values and text.

Calculates variance based on the entire population, ignoring logical values

and text.

VARP

WEIBULL

Returns the Weibull distribution.

ZTEST

Returns the two-tailed p-value of a z-test.

The functions in the Compatibility category all have new versions that were introduced in Excel 2010 or Excel

2013. The old versions are still available for compatibility.

Table A-2: Cube Category Functions

Function

What It Does

Returns a key performance indicator name, property, and

measure; and displays the name and property in the cell.

CUBEKPIMEMBER*

CUBEMEMBER*

Returns a member or tuple in a cube hierarchy.

CUBEMEMBERPROPERTY* Returns the value of a member property in the cube.

CUBERANKEDMEMBER*

Returns the
n
th, or ranked, member in a set.

Defines a calculated set of members or tuples by sending a

set expression to the cube on the server.

CUBESET*

CUBESETCOUNT*

Returns the number of items in a set.

CUBEVALUE*

Returns an aggregated value from a cube.

* Indicates a function introduced in Excel 2007.

Table A-3: Database Category Functions

Function

What It Does

Averages the values in a column of a list or database that match conditions

you specify.

DAVERAGE