New Statistical Custom Functions in Calculation Manager

Several new statistical custom functions are available:

@CalcMgrExcelBINOMDIST: Returns the individual term binomial distribution probability
@CalcMgrExcelNORMSDIST: Returns the normal distribution
@CalcMgrExcelNORMSINV: Returns the value z such that, with probability p, a standard normal random variable takes on a value that is less than or equal to z.
@CalcMgrExcelPERCENTILE: Returns the k-th percentile of values in a range
@CalcMgrExcelPERCENTRANK: Returns the rank of a value in a data set as a percentage of the data set
@CalcMgrExcelRANK: Returns the rank of a number in a list of numbers

Applies to: Financial Consolidation and Close, Planning, Tax Reporting

Business Benefit: Introduction of new custom functions makes creating calculation scripts easier.