POISSON function - The function returns the Poisson distribution in Excel
In predicting the number of events that occur within a specific time, one cannot help but use the POISSON function. The following article details how to use the POISSON function, the function returns the Poisson distribution.
Description: The function returns the Poisson distribution, which is the basis for determining the number of events occurring over a defined period, for example, with the vehicle density on weekends, the number of vehicles passing through the toll booth in 1 minute. From the anticipation, there will be specific support measures.
Syntax: POISSON (x, mean, cumulative) .
Inside:
- x: Number of events, is a required parameter.
- mean: The value to be estimated (value in the form of numbers), is a required parameter.
- cumulative: A logical value that determines the format of the return value. The following values are available:
+ cumulative = TRUE => function returns the cumulative Poisson probability that 0
+ cumulative = FALSE: function returns the cumulative Poisson probability that the number of events = x.
Attention:
- Poission function is calculated by the formula:
+ cumulative = TRUE:
+ cumulative = FALSE:
- If x is a decimal, the function takes an integer value of x.
- x and the value must be numeric otherwise the function returns the #VALUE error.
- If x
- If mean the function returns the value #NUM !.
For example:
- Calculate Poission when cumulative = True :
In the cell to calculate enter the formula: = POISSON (D13, D14, D15) .
Pressing Enter results as:
- Calculate Poission when cumulative = False :
In the cell to calculate enter the formula: = POISSON (D13, D14, D16) .
Pressing Enter results as:
Thus the Poission function value at the cumulative value is different. Hopefully the Poission function will help you in predicting events that occur in a specified time period.
Good luck!
You should read it
- GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel
- GAMMA.DIST function - The function returns the gamma distribution in Excel
- CHIDIST function - Function returns the right end probability of the distribution when squared in Excel
- PHI function - The function returns the value of the density function for a normal distribution in Excel
- BETA.DIST function - The function returns the Beta distribution in Excel
- BETA.INV function - The function returns the inverse of the cumulative distribution function for a specified beta distribution in Excel
- LOGNORM.INV function - The function returns the inverse of the logarithmic distribution of x in Excel
- T.INV function - The function returns the inverse value of the Student t distribution in Excel
May be interested
- T.INV function - The function returns the inverse value of the Student t distribution in Excelt.inv: the function returns the inverse value of the student t-distribution. support functions from excel 2010 onwards. syntax: t.inv (probability, deg_freedom)
- T.DIST.RT - The function returns the Student's t-distribution on the right in Excelt.dist.rt: the function returns the student's t-distribution on the right. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist.rt (x, deg_freedom)
- F.DIST - The function returns the probability distribution F in Excelf.dist function: the function returns the probability distribution f. the function supports the version from excel 2010. syntax: f.dist (x, deg_freedom1, deg_freedom2, cumulative)
- HYPGEOM.DIST - The function returns the hyperbolic distribution in Excelhypgeom.dist: the function returns the hyperinfection distribution, using this function for problems with finite sets of vowismooix observations whether or not they are successful. syntax: hypgeom.dist (sample_s, number_sample, population_s, number_pop, cumulative)
- F.INV function - The function returns the inverse of the probability distribution F in Excelf.inv function: the function returns the inverse of the probability distribution f. support function from the excel 2010 version. syntax: f.inv (probability, deg_freedom1, deg_freedom2)
- F.INV.RT function - The function returns the right-inverse head value of the probability distribution F in Excelf.inv.rt function: the function returns the inverse of the right probability distribution f. support functions from the excel 2010 version. syntax: f.inv.rt (probability, deg_freedom1, deg_freedom2)
- CHISQ.DIST - Function returns the distribution when squared in Excelchisq.dist: the function returns the distribution when squared, and this value is often used to understand variations as a percentage of the samples. support function from excel 2010 version. syntax: chisq.dist (x, deg_freedom, cumulative)
- LOGNORM.DIST - Function returns the logarithmic distribution of x in Excellognorm.dist: the function returns the logarithmic distribution of x. where ln (x) is usually distributed with parameter mean and standard deviation. support functions from excel 2010 onwards. syntax: lognorm.dist (x, mean, standard_dev, cumulative)
- T.DIST - The function returns the Student t-distribution on the left in Excelt.dist: the function returns the student's t-distribution on the left. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist (x, deg_freedom, cumulative)
- T.DIST.2T - The function returns the two-tailed Student distribution in Excelt.dist.2t: the function returns the two-tailed student's t-distribution. functions used in testing the hypothesis of small numbers of data sets. support functions from excel 2010 onwards. syntax: t.dist.2t (x, deg_freedom)