The output of the function is visualized by drawing the bell-shaped curve defined by the input to the function. If the cumulative flag is set to TRUE, the return value is equal to the area to the left of the input. If the cumulative flag is set to FALSE, the return value is equal to the value on the curve.
Explanation
The normal PDF is a bell-shaped probability density function described by two values: the mean and standard deviation. Themean represents the center or “balancing point” of the distribution. The standard deviation represents how spread out around the distribution is around the mean. The area under the normal distribution is always equal to 1 and is proportional to the standard deviation as shown in the figure below. For example, 68.3% of the area will always lie within one standard deviation of the mean.
Probability density functions model problems over continuous ranges. The area under the function represents the probability of an event occurring in that range. For example, the probability of a student scoring exactly 93.41% on a test is very unlikely. Instead, it is reasonable to compute the probability of the student scoring between 90% and 95% on the test. Assuming that the test scores are normally distributed, the probability can be calculated using the output of the cumulative distribution function as shown in the formula below. In this example, if we substitute a mean of 80 in for μ and a standard deviation of 10 in for σ, then the probability of the student scoring between 90 and 95 out of 100 is 9.18%. Images courtesy of wumbo.net.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
