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 472 times)
edit: nvm