Microsoft Office Tutorials and References
In Depth Information
Calculates standard deviation based on the entire population, ignoring text
and logical values.
Returns the Student's t-distribution.
Returns the inverse of the Student's t-distribution.
Returns the probability associated with a Student's t-test.
Estimates variance based on a sample, ignoring logical values and text.
Calculates variance based on the entire population, ignoring logical values
Returns the Weibull distribution.
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
What It Does
Returns a key performance indicator name, property, and
measure; and displays the name and property in the cell.
Returns a member or tuple in a cube hierarchy.
CUBEMEMBERPROPERTY* Returns the value of a member property in the cube.
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.
Returns the number of items in a set.
Returns an aggregated value from a cube.
* Indicates a function introduced in Excel 2007.
Table A-3: Database Category Functions
What It Does
Averages the values in a column of a list or database that match conditions