NORMSDIST function

Description

Returns a one-tailed probability from the standardized Normal distribution. NORMSDIST(z) returns the one-tailed probability associated with the standardized Normal deviate z.

Examples

NORMSDIST(-1.96) returns 0.025 (rounded)

NORMSDIST(1.96) returns 0.975 (rounded)

NORMSDIST(0) returns 0.5

Calculator

NORMSDIST()

Graph

NORMSDIST function
Function: NORMSDIST()
  X-axis Y-axis
Minimum:
Maximum:
Help  

Worked-out example: convert z-scores to percentiles

Suppose you have a variable named ZSCORE, containing z-scores which you want to convert to percentiles as in the following example.

Convert z-scores to percentiles - example step 1

The Fill column procedure is used with the following formula: NORMSDIST(ZSCORE)

Convert z-scores to percentiles - example step 2

Column B is filled with the percentile corresponding with the z-scores in column A:

Convert z-scores to percentiles - example step 3

See also

This site uses cookies to store information on your computer. More info...