Formulas and Functions
اس کنٹرول میں ترمیم کرنے سے یہ صفحہ آٹومیٹک طریقے سے اپڈیٹ ہو جائے گا

NORMDIST

The NORMDIST function returns the normal distribution of the specified function form.

NORMDIST(num, average, stdev, form-type)

num: The number value to be evaluated.

average: A number value representing the known average (arithmetic mean) rate at which events occur.

stdev: A number value representing the standard deviation of the population. stdev must be greater than 0.

form-type: A modal value that indicates which form of the exponential function to provide.

cumulative form (TRUE or 1): Return the value of the cumulative distribution form.

probability density form (FALSE or 0): Return the value of the probability density form.

Notes

  • If average is 0, stdev is 1 and form-type is TRUE, NORMDIST returns the same value as the cumulative standard normal distribution returned by NORMSDIST.

Examples

=NORMDIST(22, 15, 2.5, 1) returns 0.997444869669572, the cumulative distribution form.

=NORMDIST(22, 15, 2.5, 0) returns 0.00316618063319199, the probability density form.

See alsoNORMINVNORMSDIST
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
مددگار؟
حروف کی حد: 250
حروف کی زیادہ سے زیادہ حد 250 ہے۔
آپ کے تاثرات کا شکریہ۔
Morty Proxy This is a proxified and sanitized view of the page, visit original site.