Excel 2010 Bible

Appendix A: Worksheet Function Reference

919

Function What It Does

PERCENTRANK Returns the percentage rank of a value in a data set.

POISSON Returns the Poisson distribution.

QUARTILE Returns the quartile of a data set.

RANK Returns the rank of a number in a list of numbers.

STDEVP Calculates standard deviation based on the entire population, ignoring text and logical values.

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.

VARP Calculates variance based on the entire population, ignoring logical values and text.

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 in Excel 2010. The new versions are

listed in the Statistical category. The old versions are still available for compatibility.

TABLE A.2

Cube Category Functions

Function What It Does

CUBEKPIMEMBER* Returns a key performance indicator name, property, and measure, and displays

the name and property in the cell.

CUBEMEMBER* Returns a member or tuple in a cube hierarchy.

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

CUBERANKEDMEMBER* Returns the nth, or ranked, member in a set.

CUBESET* Defines a calculated set of members or tuples by sending a set expression to the

cube on the server.

CUBESETCOUNT* Returns the number of items in a set.

CUBEVALUE* Returns an aggregated value from a cube.

* Indicates a function introduced in Excel 2007.

56_474877-bapp01.indd 91956_474877-bapp01.indd 919 3/29/10 11:49 PM3/29/10 11:49 PM