Practice free

NORM.S.DIST function

NORM.S.DIST turns a z-score into a probability on the standard normal curve, which has a mean of 0 and a standard deviation of 1. It is a usual step in hypothesis testing.

Example

Read it as a sentence: find the cumulative chance of a standard normal value at or below 1.96, which gives 0.975002105.

Practice this in the app

Syntax

NORM.S.DIST(z, cumulative)

z (required)
The z-score (standard deviations from the mean).
cumulative (required)
TRUE for the area to the left of z, FALSE for the curve height at z.

Returns: The standard normal probability or density at z.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=NORM.S.DIST(1.96,TRUE) 0.975002105 Working example
=NORM.S.DIST(1.96,FALSE) 0.058440944 Other cumulative flag
=NORM.S.DIST(1.96,0) 0.058440944 Cumulative as 0
=NORM.S.DIST("1.96",TRUE) 0.975002105 Text-number in first arg
=NORM.S.DIST({1.96,1.96},TRUE) 0.975002105 Array in first arg (lifts, spills)
=NORM.S.DIST(40,TRUE) 1 Large z
=NORM.S.DIST("abc",TRUE) #VALUE! Non-numeric text in first arg
=NORM.S.DIST(NA(),TRUE) #N/A Error in first arg

Watch out for

  • The second argument is required here, unlike the old NORMSDIST.
  • z of 1.96 returns about 0.975 when cumulative.

Where it works

Excel
NORM.S.DIST arrived in Excel 2010. Older versions do not have it.
Google Sheets
Same name, same behaviour for everyday use.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .