Difference between revisions of "Manuals/calci/POISSONDISTRIBUTION"
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''RANDOMNUMBERGENERATION'''(Number, RandomNumber, Distribution, NewTableFlag, Lambda) where, '''Number '''-...") |
|||
Line 1: | Line 1: | ||
+ | <div style="font-size:30px">'''POISSONDISTRIBUTED(a,b)'''</div><br/> | ||
+ | *<math>a</math> is the number of random numbers to display. | ||
+ | |||
+ | ==Description== | ||
+ | *This function shows the random variables of Poisson distribution. | ||
+ | *It is a discrete frequency distribution which gives the probability of a number of independent events occurring in a fixed time. | ||
+ | *A Poisson random variable is the number of successes that result from a Poisson experiment. | ||
+ | *The probability distribution of a Poisson random variable is called a Poisson distribution. | ||
+ | *Suppose we conduct a Poisson experiment, in which the average number of successes within a given region is <math>\mu</math>. | ||
+ | *Then, the Poisson probability is: | ||
+ | <math>P(x;\mu) = \frac{(e-\mu) (\mu x)}{ x!}</math> | ||
+ | *where x is the actual number of successes that result from the experiment, and e is approximately equal to 2.71828. | ||
+ | *The Poisson distribution has the following properties: | ||
+ | #The mean of the distribution is equal to <math>\mu</math> . | ||
+ | #The variance is also equal to <math>\mu</math> . | ||
+ | |||
+ | |||
+ | |||
+ | |||
<div id="6SpaceContent" class="zcontent" align="left"> | <div id="6SpaceContent" class="zcontent" align="left"> | ||
Line 23: | Line 42: | ||
Lets see an example in (Column1Row1) | Lets see an example in (Column1Row1) | ||
− | + | UNIQa09fd274c5c89988-nowiki-00000004-QINU | |
RANDOMNUMBERGENERATION returns the result in new sheet(13Space). | RANDOMNUMBERGENERATION returns the result in new sheet(13Space). | ||
− | + | UNIQa09fd274c5c89988-nowiki-00000005-QINU | |
RANDOMNUMBERGENERATION returns the #ERROR(Lambda < 0). | RANDOMNUMBERGENERATION returns the #ERROR(Lambda < 0). |
Revision as of 06:46, 27 October 2015
- is the number of random numbers to display.
Description
- This function shows the random variables of Poisson distribution.
- It is a discrete frequency distribution which gives the probability of a number of independent events occurring in a fixed time.
- A Poisson random variable is the number of successes that result from a Poisson experiment.
- The probability distribution of a Poisson random variable is called a Poisson distribution.
- Suppose we conduct a Poisson experiment, in which the average number of successes within a given region is .
- Then, the Poisson probability is:
- where x is the actual number of successes that result from the experiment, and e is approximately equal to 2.71828.
- The Poisson distribution has the following properties:
- The mean of the distribution is equal to .
- The variance is also equal to .
RANDOMNUMBERGENERATION(Number, RandomNumber, Distribution, NewTableFlag, Lambda)
where,
Number - represents the number of variables.
RandomNumber - represents the number of random number
Distribution - represents the distribution method(i.e poisson) to create random values.
NewTableFlag - is the TRUE or FALSE.If set as TRUE,the result in new sheet. If NewTableFlag is omitted, it assumed to be FALSE.
Lambda - represents the probability value and should be in range 0 to 1.
Lets see an example in (Column1Row1)
?UNIQa09fd274c5c89988-nowiki-00000004-QINU?
RANDOMNUMBERGENERATION returns the result in new sheet(13Space).
?UNIQa09fd274c5c89988-nowiki-00000005-QINU?
RANDOMNUMBERGENERATION returns the #ERROR(Lambda < 0).
RANDOM NUMBER GENERATION : POISSON
If Number < 0 or RandomNumber < 0, RANDOMNUMBERGENERATION returns the #ERROR.
RANDOMNUMBERGENERATION returns the #ERROR, if Lambda < 0.
0 | 1 | 1 |
1 | 0 | 2 |
0 | 2 | 1 |
1 | 1 | 1 |
0 | 0 | 1 |
1 | 1 | 2 |
0 | 1 | 0 |
2 | 2 | 1 |
Column1 | Column2 | Column3 | Column4 | |
Row1 | 13Space | |||
Row2 | ||||
Row3 | ||||
Row4 | #ERROR | |||
Row5 | ||||
Row6 |
File:Calci1.gif | $ |
0 | 0 | 0 |
1 | 0 | 1 |
1 | 0 | 1 |
0 | 0 | 0 |