Gaussian distribution<\/strong>, and it gives us the probability distribution that is symmetric about the mean. What it shows is that the data near the mean occur more often than data far from the mean.<\/p>\n\n\n\nIn the example below, we will show how to calculate the probability of a value occurring in a normal distribution<\/strong>.<\/p>\n\n\n\nCalculate Normal Distribution Probability in Excel<\/h2>\n\n\n\n For our example, we will use three values that will be located in column A<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nTo calculate the probability of a certain value lined above occurring in a normal distribution, we will use NORM.DIST function<\/strong>. This function takes into account the value for which we are finding the probability, the mean, and the standard deviation<\/strong>, and checks if we want the cumulative distribution or the probability density.<\/p>\n\n\n\nThe syntax for the NORM.DIST function<\/strong> is as follows:<\/p>\n\n\n\nNORM.DIST(x, mean, standard_dev, cumulative)<\/code><\/pre>\n\n\n\nIn this formula:<\/p>\n\n\n\n
\nX:<\/strong> It is the value for which we want to calculate the probability.<\/li>\n\n\n\nMean:<\/strong> Mean of the normal distribution.<\/li>\n\n\n\nStandard_dev:<\/strong> Standard deviation of the normal distribution.<\/li>\n\n\n\nCumulative:<\/strong> Logical value that indicates if we want a cumulative distribution<\/strong> (we will get this if we set the value to TRUE<\/strong>), or probability density (we will get this if we choose FALSE).<\/li>\n<\/ul>\n\n\n\nFor our example, we have the X values<\/strong>, but we are missing the rest of the data. We will calculate the mean using the MEDIAN formula in column B<\/strong>, using the formula:<\/p>\n\n\n\n=MEDIAN($A$2:$A$4)<\/code><\/pre>\n\n\n\nAnd will get the result 105<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nWe also need to calculate the standard deviation, and we will do it by inserting the following formula in cell C2:<\/strong><\/p>\n\n\n\n=STDEV($A$2:$A$4)<\/code><\/pre>\n\n\n\nAnd we will get the result of 12.58<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nNow, for the final part, we will calculate the normal distribution probability<\/strong> for our values with cumulative distribution in column D<\/strong> by using the following formula:<\/p>\n\n\n\n=NORM.DIST(A2,B2,C2,TRUE)<\/code><\/pre>\n\n\n\nAnd will get the following results:<\/p>\n\n\n\n <\/figure>\n\n\n\nAnd one more for probability density (using FALSE) in column E<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\nInterpreting the Results of Normal Distribution Probability<\/h2>\n\n\n\n The NORM.DIST function<\/strong> gives us us the probability of a certain value occurring in a normal distribution. The result will tell us the probability of the random variable from a normal distribution being less or equal to a specific value.<\/p>\n\n\n\nTo interpret the result, values between 0.5 and 1<\/strong> (for example our value of 0.88<\/strong>) indicate that the value we are calculating the probability for is somewhere between the mean and the right tail of the distribution<\/strong>.<\/p>\n\n\n\nValues between 0 and 0.5 (in our case, 0.21)<\/strong> indicate that the values we are calculating the probability for are somewhere between the mean and the left tail of the distribution<\/strong>.<\/p>\n\n\n\nTo summarize, the NORM.DIST function<\/strong> gives us insight into the likelihood of a random variable being below a certain value in a normal distribution<\/strong>. This information is useful for making statistical inferences, setting confidence intervals, and understanding the behavior of random variables within a normal distribution context.<\/p>\n","protected":false},"excerpt":{"rendered":"There are a lot of statistical measures and terms that are used and can be calculated using Excel. One of these terms is…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"\n
Calculate Normal Distribution Probability in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n