:NORM.DIST function-Table skills免费ppt模版下载-道格办公

Picture and text skills
Case

Returns the normal distribution function with the specified mean and standard deviation. This function has a wide range of applications in statistics (including hypothesis testing).

Grammar

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

NORM.DIST function syntax has the following parameters:

X: required. Its distribution needs to be calculated.

Mean: Required. The arithmetic mean of the distribution.

standard_dev: required. The standard deviation of the distribution.

Cumulative: required. Determine the logical value of the function form. Standard if cumulative is TRUE.

DIST returns the cumulative distribution function; if FALSE, returns the probability density function.

Description

￭If mean or standard_dev is non-numeric, NORM.DIST returns the #VALUE! error value.

￭If standard_dev ≤ 0, NORM.DIST returns the #NUM! error value.

￭If mean = 0, standard_dev = 1, and cumulative = TRUE,

NORM.DIST returns the standard normal distribution, that is, NORM.S.DIST.

￭The formula of the normal distribution density function (cumulative = FALSE) is:

NORM.DIST.png

￭If cumulative = TRUE, the formula is the integral from negative infinity to X known in the formula.

Example

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/NORM-DIST-han-shu.html