:"Exploring the uses and cases of the NORM.S.DIST function"-Table skills免费ppt模版下载-道格办公

"Exploring the uses and cases of the NORM.S.DIST function"

  • Picture and text skills
  • Case

Returns the standard normal distribution function (a distribution with mean 0 and standard deviation 1).

You can use this function in place of the standard normal curve area table.

Syntax - Standard Normal Distribution

NORM.S.DIST(z,cumulative)

NORM.S.DIST function syntax has the following parameters:

Z: required. Its distribution needs to be calculated.

cumulative: required. Cumulative is a logical value that determines the form of a function.

NORMS.DIST returns the cumulative distribution function if cumulative is TRUE; if FALSE, it returns the probability density function.

Description

■If z is non-numeric, NORM.S.DIST returns the #VALUE! error value.

■The formula of the standard normal distribution density function is:

NORM.S.DIST.png

Example

image.png
Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion