Table of Contents
The EXPON.DIST function in Google Sheets is a statistical function that allows users to calculate the probability of a specific value occurring in a set of data that follows an exponential distribution. To use this function, users must input the value, mean, and cumulative value of the data set. The result will be a decimal number representing the probability of the given value occurring. This function can be helpful in analyzing data sets that follow an exponential pattern, such as time between occurrences or decay rates. By utilizing the EXPON.DIST function, users can gain valuable insights and make informed decisions based on the probability of certain values occurring in their data.
EXPON.DIST
Returns the value of the exponential distribution function with a specified lambda at a specified value.
Sample Usage
EXPON.DIST(4,0.5,FALSE)
EXPON.DIST(A2,A3,A4)
Syntax
EXPON.DIST(x, lambda, cumulative)
x– The input to the exponential distribution function.- If
cumulativeisTRUEthenEXPON.DISTreturns the cumulative probability of all values up tox.
- If
lambda– The lambda to specify the exponential distribution function.cumulative– Whether to use the exponential cumulative distribution.
Note
- You can use
EXPONDISTorEXPON.DISTto perform this function.
See Also
WEIBULL: Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.
POISSON: Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.
NORMSINV: Returns the value of the inverse standard normal distribution function for a specified value.
NORMSDIST: Returns the value of the standard normal cumulative distribution function for a specified value.
NORMINV: Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.
NORMDIST: The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
NEGBINOMDIST: Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.
LOGNORMDIST: Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.
LOGINV: Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.
HYPGEOMDIST: Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws.
BINOMDIST: Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdEJvRTc5NzljZ0U0NU0xWUxIWnZDenc&output=html” width=”500″]
Cite this article
stats writer (2024). How can I use the EXPON.DIST function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-expon-dist-function-in-google-sheets/
stats writer. "How can I use the EXPON.DIST function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-expon-dist-function-in-google-sheets/.
stats writer. "How can I use the EXPON.DIST function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-expon-dist-function-in-google-sheets/.
stats writer (2024) 'How can I use the EXPON.DIST function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-expon-dist-function-in-google-sheets/.
[1] stats writer, "How can I use the EXPON.DIST function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the EXPON.DIST function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.