DEV Community

Andrews
Andrews

Posted on • Originally published at geekexcel.com on

How to use the LOGNORM.DIST function in Excel office 365?

#tousethelognormdistf #excel #excelfunctions

The LOGNORM.DIST function is a built-in statistical function that returns the probability for the log-normal distribution. It takes the 3 arguments with the type of distribution function (cdf or pdf). The log-normal distribution is a continuous probability distribution of a random variable whose logarithm is normally distributed. A random variable that is log-normally distributed takes only positive real values. It is a convenient and useful model for measurements in exact and engineering sciences as well as medicine, economics, and other fields.

In this tutorial, we are going to see how to use the LOGNORM.DIST Function In Excel Office 365. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

LOGNORM.DIST Function syntax 

=LOGNORM.DIST(x, mean, std_dev, cumulative)
Enter fullscreen mode Exit fullscreen mode

Syntax Explanation:

  • x : value at which distribution is evaluated.
  • mean : mean of log normal distribution.
  • std_dev : standard deviation of log normal distribution.
  • cumulative : logical value that determines the form of the function. If cumulative is TRUE , LOGNORM.DIST returns the cumulative distribution function ; if FALSE , it returns the probability density function.

Example

  • Firstly, you need to create the sample data with x value , mean value and standard deviation value.

Sample data

  • Then, you have to calculate the cumulative for the log normal distribution function.
  • Now, you need to use the following formula given below. 
=LOGNORM.DIST ( B2, B3, B4, FALSE)
Enter fullscreen mode Exit fullscreen mode

Cumulative distribution

  • After that, you can find out the probability value for the log normal distribution function for the value at least 5 following the same parameters with the formula shown below. 
=LOGNORM.DIST ( B2, B3, B4, TRUE)
Enter fullscreen mode Exit fullscreen mode

probability mass distribution

  • After that, you have to perform the inverse function of the log normal distribution.
  • Finally, you need to find the x value using the probability value, mean value and standard deviation using the LOGNORM.INV function in Excel.

NOTES:

  • The LOGNORM.DIST Function only works with numbers.
  • If any argument other than cumulative is non-numeric , the function returns #VALUE! error.
  • The function returns #NUM! Error.
    1. If argument x < 0
  1. If argument mean <= 0
  2. If argument std_dev < 0
    • Then, the argument x event is truncated to integers if not.
    • Now, the cumulative argument can be used with boolean numbers (0 and 1) or (FALSE or TRUE).
    • After that, the value in decimal and value in percentage id the same value in Excel and convert the value to percentage , if required.
    • Finally, you can feed the arguments to the function directly or using the cell reference, as explained in the example.

Closure

From this article, you can get to know the formulas for how to use the LOGNORM.DIST Function In Excel Office 365. Hope that this article is useful to you. Kindly, drop your feedback in the below sections. Thank you so much for Visiting Our Site!! Continue learning on Geek Excel!! *Read more on Excel Formulas *!!

Read Also:

Top comments (0)