Collapse All Expand All

This function returns the normal distribution for the specified mean and standard deviation.

Syntax

NORM.DIST(x,mean,stdev,cumulative)

Arguments

This function has these arguments:

Argument	Description
x	Value for which to find the distribution
mean	Arithmetic mean of the distribution
stdev	Standard deviation of the distribution Must be greater than zero.
cumulative	Set to TRUE to return the cumulative distribution function. Set to FALSE to return the probability mass function.

Remarks

If mean = 0, stdev = 1, and cumulative = TRUE, this function returns the standard normal distribution, NORMSDIST.

Data Types

The x, mean, and stdev arguments accept numeric data. The cumulative argument accepts logical data. Returns numeric data.

Examples

NORM.DIST(10,A3,B17,FALSE)

NORM.DIST(10,R3C1,R17C2,FALSE)

NORM.DIST(37,41.125,9.86,TRUE) gives the result 0.3378430609671818

 

 

---

Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.