After installing Kutools for Excel, Please do as follows: 1. Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days. In the 21st century it’s pretty easy to calculate the binomial probabilities directly. The user can specify whether the probability density function or the cumulative distribution function is used. Note that in recent versions of Excel (Excel 2010 and later), the Expondist function has been renamed the Expon.Dist function. The Excel Expondist function returns the value of the exponential distribution for a give value of x. When β = 1, it corresponds to the standard gamma distribution. Exponential distribution Where do you meet this distribution? ©2013 Matt Bognar Department of Statistics and Actuarial Science University of Iowa Get it Now. The Operation Tools of Kutools for Excel can help you to solve this problem quickly and easily. Exponential Distribution Using Excel In this tutorial, we are going to use Excel to calculate problems using the exponential distribution. To follow through with the calculations, type 2 into the X box to calculate pr(2), and 3 to find pr(3). In the example, you see the probability for two defective joints in 1,000 and the probability for three. The POISSON function calculates probabilities for Poisson distributions. The function uses the syntax =POISSON(x,mean,cumulative) where x is the number of events, is the arithmetic mean, and cumulative is a switch. When α = 1, it corresponds to exponential distribution. Highlight the range you want to do the exponential calculation. POISSON: Poisson distribution probabilities. We will solve a problem with data that is distributed exponentially with a mean of 0.2, and we want to know the probability that X will be less than 10 or lies between 5 and 10. Alpha / α (Required) – A parameter of the distribution used for determining the shape. beta / β (Required) – A parameter of the distribution for determining the rate; α and β are both must be greater than 1. 2.