21

**Physics, Astronomy & Cosmology / Re: How do you use decay constant formula to find decay in excel?**

« **on:**03/03/2018 10:45:04 »

Ok, I've had a go...

I simulate 16 dice -

- Each row represents one half life, numbered in Column A

- Column B shows the theoretical number present after this many half-lives. Note that this number becomes a fraction, while real dice can't become a fraction.

- if the dice face shows a number > 3, it continues into the next round.

- Column C counts how many dice are left

- Press F9 to recalculate (start with the full number of dice again)

- The results are slightly different every time you press F9

- You can experiment with more dice by duplicating column S in more columns to the right.

- There is a similar experiment on the "Coin" worksheet, simulating flipping a lot of coins. Only half of them are left after a half-life.

But I can't upload EXCEL files.

Download the file to disk, then remove the JPG suffix.

Scan with a virus scanner. Then it should open in EXCEL.

Dice_Sim.xlsx.jpg (26.99 kB - downloaded 477 times)

edit: nvm