NORM.DIST
Formulas / NORM.DISTCalculate values and areas for the normal probability density function and the normal cumulative distribution function.
NORM.DIST(x,mean,standard_dev,cumulative)
- X - required, the value for which you want the distribution
- mean - required, the arithmetic mean of the distribution
- standard_dev - required, the standard deviation of the distribution
- cumulative - required, a logical value that determines the form of the function
Examples
=NORM.DIST(A2,A3,A4,TRUE)The NORM.DIST function is used to calculate the cumulative distribution function (CDF) or probability mass function (PMF) of a given set of terms. This will return the cumulative distribution function for the terms in A2, A3, and A4.
=NORM.DIST(A2,A3,A4,FALSE)This will return the probability mass function for the terms in the given order.
Summary
The NORM.DIST function is a useful tool in statistics, as it calculates the normal distribution. It is used in hypothesis testing and has many applications.
- The NORM.DIST function returns values for the normal probability density function (PDF) and the normal cumulative distribution function (CDF)
- The output of the PDF and CDF distributions are drawn using the bell-shaped curve
Need help with Formulas?
Frequently Asked Questions
What is the NORM.DIST function?
The NORM.DIST function calculates the probability that a variable falls below or at a specified value. It calculates the normal probability density function or cumulative normal distribution function for a set of parameters.
What is the NORM.DIST function used for?
The NORM.DIST function is used for stock market analysis. It quantifies risk and return by calculating the mean and standard deviation for returns and risk.
What kind of normal distribution does the NORM.DIST function refer to?
The NORM.DIST function refers to any normal distribution.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV