1 / 10

Nuclear Decay Revisited

Enter the probability of decay (.083/day) for Iodine-131 and simulate decay using IF and RAND() functions in Excel over 30 days. Sum simulated decays and create an XY Scatter graph to visualize the decay curve. Calculate the percentage of undecayed atoms after 8, 16, and 24 days based on the fit formula.

morse
Télécharger la présentation

Nuclear Decay Revisited

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Nuclear Decay Revisited

  2. Enter the probability to decay in a time unit – approximately 0.083 for Iodine 131 to decay in one day. Also make a row of day numbers 0 to 30.

  3. Enter 1000 1’s (shown in Col B below) and Sum them at the top of the column under the Day numbers.

  4. Use IF and RAND() to simulate decay (a change from 1 to 0).

  5. Copy the formula down. (Get the “thin cross” and double click.)

  6. Copy the sum formula over. You should see about 8.3% of the “atoms” decayed.

  7. Copy the formula for the simulated atoms and the sum over for the 30 days.

  8. Highlight the Day and Sum rows and make an XY Scatter graph.

  9. Fit to an Exponential, label axes, title, etc.

  10. Interpolation • According to your fit formula, what percentage of atoms are left (un-decayed) after 8 days? • 16 days? • 24 days?

More Related