Definition

Returns the standard normal distribution (has a mean of zero and a standard deviation of one).

Use this function in place of a table of standard normal curve areas.

Sample Usage

Syntax – Standard Normal Distribution
NORM.S.DIST(z,cumulative)
The NORM.S.DIST function syntax has the following arguments:
  • Z     Required. The value for which you want the distribution.
  • Cumulative     Required. Cumulative is a logical value that determines the form of the function. If cumulative is TRUE, NORMS.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function.
Remarks
  • If z is nonnumeric, NORM.S.DIST returns the #VALUE! error value.
  • The equation for the standard normal density function is:
    Equation
In order to use the NORM.S.DIST formula, start with your edited Excellentable
Then type in the NORM.S.DIST formula in the area you would like to display the outcome:
By adding the values you would like to calculate the NORM.S.DIST formula for, Excellentable will generate the outcome:





  
    
      



    

        
        Error.
    

    
User does not have sufficient privileges to access this Content 
Learn More