1. Designing with Calculation Manager
  2. Using Member Selection, Variables, Functions, Smart Lists, and Planning Formula Expressions to Design Components
  3. Working with Custom Functions
  4. Statistical Functions
  5. @CalcMgrExcelNORMSINV

@CalcMgrExcelNORMSINV

Purpose:

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. A standard normal random variable has mean 0 and standard deviation 1.

Syntax:

Java Class: com.hyperion.calcmgr.common.excel.cdf.ExcelStatisticalFunctions.NORMSINV(double)

CDF Spec: @CalcMgrExcelNORMSINV(probability)