PHI

density function value for the standard normal distribution · from excel · excel: not yet compared · sheets: not yet compared

signature

PHI(x)

returns: number

argumentrequired
x required

examples

formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.

fx =PHI(2) 0.05399096651318806

related

  • AVEDEV average of absolute deviations from the mean
  • AVERAGE.WEIGHTED average of values weighted by a second range
  • AVERAGEA averages values including text and logicals
  • AVERAGEIF averages cells that match a condition
  • AVERAGEIFS averages cells matching multiple conditions
  • BETA.DIST beta distribution