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
Search JabSto ::




Custom Search