Difference between revisions of "Manuals/calci/NORMSDIST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 13: Line 13:
 
#=NORMSDIST(1.00006) = 0.8413586589
 
#=NORMSDIST(1.00006) = 0.8413586589
 
#=NORMSDIST(12) = 1.0000002451499
 
#=NORMSDIST(12) = 1.0000002451499
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|F2rKy2cI8Ss|280|center|NORMSDIST}}
  
 
==See Also==
 
==See Also==

Revision as of 20:33, 19 June 2015

NORMSDIST(x)


  • is the value of the function

Description

  • This function gives the Standard Normal Cumulative Distribution function.
  • In Normal Distribution formula, if the Mean is zero and the Standard Deviation is 1, then it is called Standard Normal Distribution.
  • The equation for the Standard Normal Density function is:
  • This function will return the result as error when the value is non-numeric.

Examples

  1. =NORMSDIST(4.74) = 0.9999975333
  2. =NORMSDIST(5.0021) = 0.9999999738
  3. =NORMSDIST(1.00006) = 0.8413586589
  4. =NORMSDIST(12) = 1.0000002451499

Related Videos

NORMSDIST

See Also

References

Normal distribution