Functions
NORM.DIST
Normal CDF/PDF
Try it
When to use it
When should I use NORM.DIST?
Use NORM.DIST to calculate the probability that a normally distributed variable falls at or below a given value (cumulative=TRUE), or the probability density at that value (cumulative=FALSE) — useful for grading on a curve, process capability, or confidence interval calculations.
Used in
Syntax
NORM.DIST(x,mean,stdev,cumulative)Examples
=NORM.DIST(2.4,1,4,FALSE) // => 0.09381008672923448
=NORM.DIST(2.4,1,4,TRUE) // => 0.6368306511756191
=NORM.DIST(0,0,1,TRUE) // => 0.5