- 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, or the probability density function if cumulative is FALSE.
Description
■If z is non-numeric, NORM.S.DIST returns the #VALUE! error value.
■The formula of the standard normal distribution density function is:
Example
![image.png image.png](https://font2020.oss-cn-beijing.aliyuncs.com/wps/images/676d748b13f2c9c14d4a4439768cf54c.png)
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-S-DIST-han-shu.html
评论列表(196条)
测试