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

The LOGNORM.DIST function in Microsoft Excel and Google Sheets returns the cumulative log-normal distribution of probability. A log-normal distribution is characterized by two parameters: the mean (mean) and the standard deviation (standard_dev).

Syntax

The syntax for the LOGNORM.DIST function in Excel is:

LOGNORM.DIST(x, mean, standard_dev, cumulative)

The syntax for the function in Google Sheets is:

LOGNORM.DIST(x, mean, standard_dev, cumulative)

Parameters

• x — the value at which you want to evaluate the distribution;
• mean — the mean of the distribution;
• standard_dev — the standard deviation of the distribution;
• cumulative — a logical value that determines the type of function:
  • TRUE — calculates the cumulative distribution;
  • FALSE — calculates the probability density at a given point.

Usage Examples

Let»s consider some examples where the LOGNORM.DIST function can be applied:

Example 1: Calculating Cumulative Probability

Assume we have log-normally distributed data, and we wish to determine the probability that a value will be less than or equal to a certain point x. To do this, we need to set the cumulative parameter to TRUE (or 1).

Expected result: the probability that the value is <= 10 with a mean of 5 and a standard deviation of 2.

Example 2: Calculating Probability Density

Now, let»s examine an example where we need to calculate the probability density of a log-normal distribution at a specific point x (without considering cumulative probability). For this, the cumulative parameter should be set to FALSE (or 0).

Expected result: the probability density of the log-normal distribution at point 10 with a mean of 5 and a standard deviation of 2.

Больше информации: https://support.microsoft.com/ru-ru/office/логнорм-расп-функция-логнорм-расп-eb60d00b-48a9-4217-be2b-6074aee6b070