NORM.DIST

normal distribution · from excel · excel: not yet compared · sheets: not yet compared

signature

NORM.DIST(x, mean, standard_dev, cumulative)

returns: number

argumentrequired
x required
mean required
standard_dev required
cumulative 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 =NORM.DIST(2, 3, 4, TRUE) 0.4012936743170763

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