Как пользоваться функцией EXPON.DIST в Excel

The EXPON.DIST function in Microsoft Excel and Google Sheets is used to calculate the exponential distribution of probabilities.

Syntax

The syntax for the EXPON.DIST function in Excel and Google Sheets is:

EXPON.DIST(x, lambda, cumulative)

• x — the value for which the probability density or distribution probability needs to be calculated;
• lambda — the rate parameter of the exponential distribution, which is the average number of events per time unit;
• cumulative — a logical parameter that determines whether to compute the cumulative distribution function (TRUE) or the probability density function (FALSE).

Examples

Example 1: Calculating the probability density for an exponential distribution

Assume we have an exponential distribution with a lambda parameter of 0.5. We need to find the probability density at x = 2.

In Excel, the formula would look like this:

=EXPON.DIST(2, 0.5, FALSE)

In Google Sheets, the formula is the same:

=EXPON.DIST(2, 0.5, FALSE)

Example 2: Calculating the cumulative probability for an exponential distribution

If we use the same parameters but now need to find the cumulative probability up to x = 3:

In Excel:

=EXPON.DIST(3, 0.5, TRUE)

In Google Sheets:

=EXPON.DIST(3, 0.5, TRUE)

Conclusion

The EXPON.DIST function in Excel and Google Sheets enables the analysis of exponential probability distributions by calculating both probability density and cumulative probabilities. Knowing how to use this function allows for effective data analysis related to exponential distributions in spreadsheets.

Больше информации: https://support.microsoft.com/ru-ru/office/эксп-расп-функция-эксп-расп-4c12ae24-e563-4155-bf3e-8b78b6ae140e