I am using the excel tool named "Data Analysis" -> Random number Generation and generating 100 numbers for the "Poisson" distribution. I am entering the following values in each box: "Number of Variables: 1", "Number of Random Numbers: 100", "Distribution: Poisson", and "Lambda: 5". It outputs most of the numbers from 0 to 10 as I want them. However, when I use the "countif" statement to get how many 0's,1's,2's, and so on are there, I should see that the total counted is equal to 100 because every value generated is between 0 and 10, but no. The count comes up to be sometimes 91,88,or any other number because it exceeds 10 in the random generation.
How do I keep the range from 0 to 10 no matter what distribution I use whether it is Poisson or any other one from that list?
Aucun commentaire:
Enregistrer un commentaire