How to use Excel EXPON.DIST Function

Introduction:-    

EXPON.DIST function in excel is a statistical function. This function is used to find the exponential distribution. It is an update over EXONDIST function and is available in Excel 2010 and newer versions. It is a worksheet function and can be entered into the cell in which value is required.

Syntax:-                                    

=EXPON.DIST(X, Lambda, Cumulative)

Arguments:-

X: It is the value of the function.

Lambda:  It is the value of the parameter.

Cumulative: It is a logical value which helps in determining which type of exponential function is to be used. TRUE gives cumulative distribution function and FALSE gives probability density function.

Keynotes:-

  • For non numeric value of x and lambda, #VALUE error is displayed.
  • If x<0 or lambda <=0 than #NUM error is displayed.
  • Formula for probability density function is:
  • Formula for cumulative distribution function is:

EXAMPLE

In this example, EXPON.DIST function is used to find cumulative distribution function for values present is column A and Column B and write results in column D. Value of X are given in column A and value of Lambda are given in column B respectively.

Leave a Reply

Close Menu
×

Cart