calculating normal distribution percentages in excel

#CALCULATING NORMAL DISTRIBUTION PERCENTAGES IN EXCEL HOW TO#

How to use Excel NORM.DIST Function : Calculate the Z score for the normal cumulative distribution for the pre specified values using the NORMDIST function in Excel. You can easily use this function in excel to calculate the probability of a number appearing in data set without worrying about the complex mathematics behind normal distribution function. So yeah guys, this is the NORM.DIST function of excel. The graph of PDF is normally looks like below image.

It says that there are 2% chances of a person weighing 60% kgs. Now you have the probability of each weight in data. Just writ this NORM.DIST formula in C2 and copy in below cells. I have already calculated the standard deviation and mean of the data. We have prepared another data from men in your organisation. For example, you may want to know what is the probability of a women weighing 60 kilos. The Probability Distribution Function tells the probability of occurrence of a given number in a population. The NORM.DIST function is also used for calculating PDF in Excel. How to Calculate Probability Distribution Function in Excel If you want to just know the probability of a number at a point in a data set, you should use PDF. Because as the name suggests the NORM.DIST calculates cumulative probability. The CDF graph in excel will always look like this if data is sorted ascendingly.

The graph shown below is visualisation of CDF in Excel. Now, we know that there are 79% chances of a person weighing 50 kgs or less in your company. This CDF’s tell us the probability of any number below that given number. The NORM.DIST function will return below result. Next, we have given absolute references for mean and standard deviation, respectively. It is a relative reference so that it changes when copied below. Here, B2 contains the number of which we want to get CDF.

Calculating normal distribution percentages in excel