Counting the events
I generated random number (1-6) as in DICE
How do I count the number of times a 1, 2, 3, ...... 6 occurs when I run it for, let say, 1000 times. What function should I use to keep these counts? |
=COUNTIF(A:A,1)
=COUNTIF(A:A,2) etc. HTH Jason Atlanta, GA -----Original Message----- I generated random number (1-6) as in DICE How do I count the number of times a 1, 2, 3, ...... 6 occurs when I run it for, let say, 1000 times. What function should I use to keep these counts? . |
What you have below does not do cummulative counts.
Let say I roll the dice 100 times, and I want to know how many times a 1,2,3,....6 appears. Let say I am looking at the 2, it counts the first time a 2 appears, but any time another number appears, the counter for "2" reads "0". I want something that records these counts, cummulatively... Thanks, OSJ "Jason Morin" wrote: =COUNTIF(A:A,1) =COUNTIF(A:A,2) etc. HTH Jason Atlanta, GA -----Original Message----- I generated random number (1-6) as in DICE How do I count the number of times a 1, 2, 3, ...... 6 occurs when I run it for, let say, 1000 times. What function should I use to keep these counts? . |
To clarify the problem:
I am using RANDBETWEEN(1,6) to simulate rolling the DICE. I have six Counters: [ ] [ ] [ ] [ ] [ ] [ ] reprensenting: 1 2 3 4 5 6 When I roll the DICE 100-times what I have looks similar to: [0] [0] [0] [1] [0] [0] 1 2 3 4 5 6 It keeps the last count that meets the condition, and zeroes all others. The COINTIF (A:A, 1) function, for example, returns a zero when any other number appears (when the comditon is not met). Thanks..... "Jason Morin" wrote: =COUNTIF(A:A,1) =COUNTIF(A:A,2) etc. HTH Jason Atlanta, GA -----Original Message----- I generated random number (1-6) as in DICE How do I count the number of times a 1, 2, 3, ...... 6 occurs when I run it for, let say, 1000 times. What function should I use to keep these counts? . |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com