Manuals/calci/NORMDIST
Jump to navigation
Jump to search
'
NORMDIST(x,m,sd,cu)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x} is the value,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m} is the mean,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd} is the standard deviation and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle cu} is the logical value like TRUE or FALSE.
Description
- This function gives the normal distribution for the particular mean and standard deviation.
- Normal distribution is the function that represents the distribution of many random variables as a symmetrical bell-shaped graph.
- This distribution is the continuous probability distribution.It is also called Gaussian distribution.
- In Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle NORMDIST(x,m,sd,cu) ,x} is the value of the function,Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m} is the arithmetic mean of the distribution, Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd} is the standard deviation of the distribution and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle cu} is the logical value that indicating the form of the function.
- Suppose cu is TRUE, this function gives the cumulative distribution, and it is FALSE, this function give the probability mass function.
- The equation for the normal distribution is:Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle f(x,\mu,\sigma)=1/σsqrt(2pi()).e^-{(x-μ)^2/2σ^2}} , where \mu is the mean of the distribution,\sigma is the standard deviation of the distribution.
- In this formula, Suppose \mu = 0 and \sigma = 1, then the distribution is called the standard normal distribution or the unit normal distribution.
- This function will return the result as error when any one of the argument is nonnumeric and sd<=0.
when cu is TRUE , this formula is the integral from -infinity to x and cu is FALSE , we can use the same formula.
font>sd is the standard deviation of the distribution.
c is a logical value that determines the form of the function.
It calculates the normal distribution for the specified mean and standard deviation.
· NORMDIST displays error for nonnumeric sd.
- When sd <=0, NORMDIST displays error.
- The equation for the normal density function (cumulative = FALSE) is:
NORMDIST
Let’s see an example in (Column1 Row 1, Column1Row2, Column1Row3)
NORMDIST (C1R1, C1R2, C1R3)
i.e. =NORMDIST (52, 50, 2.5, true) is 0.7885
?UNIQcc0d9c136de91e77-nowiki-00000002-QINU? is 0.1159.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |||
| Row1 | 52 | 0.7885 | 0.1159 | |||
| Row2 | 50 | |||||
| Row3 | 2.5 | |||||
| Row4 | ||||||
| Row5 | ||||||
| Row6 |