The Cumulative Distribution Function (CDF) of a continuous random variable, x, is equal to the integral of its probability density function (PDF) to the left of x. This value represents the area below the PDF to the left of the point of interest, x.

X-axis: represents z-scores of measurement

Y-axis: represents the probability of "x" or lower occurring. The range is 0-1 with 1 representing 100% of the values of "x".

A y-value of 0.5 is at the mean "x" value.

**EXAMPLE:**

If the PDF of a continuous random variable is known to be 0.08x where x is valid from 0 to 5. Find the probability (cumulative distribution function) of x being less or equal to 2.3.

The function NORM.DIST (former Excel version used NORMDIST) calculates the Normal Probability Density Function __or__ the Cumulative Normal Distribution Function.

With "x" as the point of interest, the format of the function is:

*NORMDIST(x, mean, standard deviation, TRUE or FALSE)*

In the final argument use:

- TRUE for the Cumulative Normal Distribution Function, or
- FALSE for the Normal Probability Density Function.

An example is shown below given:

x = 12.65

Mean = 12.5

Standard Deviation = 0.25

The inverse cumulative distribution function is used to estimate "x" where a certain percent of probability has occurred.

You can find the PDF, CDF, and Inverse CDF for several types of distributions. Shown below is a snapshot of the menus.

Custom Search

**Six Sigma**

**Templates, Tables & Calculators**

**Six Sigma Certification**

**Six Sigma** Modules

*Green Belt Program (1,000+ Slides)*

*Basic Statistics*

*SPC*

*Process Mapping*

*Capability Studies*

*MSA*

*Cause & Effect Matrix*

*FMEA*

*Multivariate Analysis*

*Central Limit Theorem*

*Confidence Intervals*

*Hypothesis Testing*

*T Tests*

*1-Way Anova Test*

*Chi-Square Test*

*Correlation and Regression*

*Control Plan*

*Kaizen*

*Error Proofing*