EXPON.DIST (PQL - xl)

This function returns the exponential distribution or the probability density

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

EXPON.DIST(x, lambda, cumulative)

Function Arguments

Name

Description

Type

Optional

x

Value of the function; must be positive or zero

Number

lambda

Parameter value; must be greater than zero

Number

cumulative

Logical value indicating whether to return the cumulative distribution; set to TRUE to return the cumulative distribution; set to FALSE to return the probability density

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'EXPON.DIST' function - using the same inputs, logic and outputs.