If The population of a rodent colony starts at 50 and each rodent has a probability of 1/6 that it will die of a disease each day. This can be simulated by a spreadsheet which contains 50 “dice” and on each “roll”, if the die comes out a 6, it is removed. Perform this simulation and compare it to the theoretical decline of the rodent colony.
Currently i have gotten to the point were i have done the simulation and if the rodent lands on the number 6 it dies (cell goes blank) Current formula
=IF(B2=6,"",RANDBETWEEN(1,6))
i just need to figure out if the rodent dies on, lets say day 12 all that will happen is a blank space on day 13 and will just restart the simulation on day 15
As you can see, the first rodent died on day 1 (r.i.p) so day 2 there is a blank space but on day 3 there is a random number generated (1/6) i want to know if the mouse died how can we make the rest of the cells black in the rodent colloum
Aucun commentaire:
Enregistrer un commentaire