Difference between revisions of "Manuals/calci/NORMSDIST"

From ZCubes Wiki
Jump to navigation Jump to search
Line 10: Line 10:
  
 
==Examples==
 
==Examples==
#NORMSDIST(4.74)=0.9999975333
+
#=NORMSDIST(4.74) = 0.9999975333
#NORMSDIST(5.0021)=0.9999999738
+
#=NORMSDIST(5.0021) = 0.9999999738
#NORMSDIST(1.00006)=0.8413586589
+
#=NORMSDIST(1.00006) = 0.8413586589
#NORMSDIST(12)=1.0000002451499
+
#=NORMSDIST(12) = 1.0000002451499
  
 
==See Also==
 
==See Also==

Revision as of 00:00, 7 January 2014

NORMSDIST(x)


  • is the value of the function


Description

  • This function gives the Standard normal cumulative distribution function.
  • In normal distribution formula, when 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 x value is nonnumeric.

Examples

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

See Also

References

Normal distribution