Radioactive decay simulation | Chemistry |

background [prelab assignment (30 points) due at the beginning of lab]

describe a method using graphical analysis (of a graph of # radioactive isotopes versus time) to determine the half-life of a radioactive isotope

describe a method using graphical analysis (of a graph of ln # radioactive isotopes versus time) to determine the decay constant of a radioactive isotope

describe the Excel command / syntax for __ [put a copy of the below content in your lab NB]

- randbetween
- count
- countif
- countifs

purpose

develop an Excel-based model to simulate radioactive isotope decay (start with 100 & end with < 15 simulated isotopes; read below content of your lab report for other aspects of the lab)

determine the half-life and decay constant; compare 6- versus 10- sided dice

compare results (i.e. decay constant determination) from least squares analysis versus "Excel regression analysis"

materials

Microsoft Excel template

methods / data analysis

student design

Content of lab report [45 points]

data analysis- for 6- & 10- sided dice

- screenshoot of your Excel simulation (i.e. "step 3"), which includes the row / columm labels. include the Excel commands in your simulation in the yellow high-lighted cells (show the syntax and its parameters for each Excel command; 10 points)
- 2 plots on the same chart / graph for 6- & 10- sided dice; 10 points)

- figure 1: # dice versus # dice roll (use Excel's trendline --> exponential; don't include parameters of eqn & R
^{ 2})- figure 2: ln (# dice) versus # dice roll (use Excel's trendline --> linear regression feature)
- determine the half-life for each type of dice using the preceding graphs; include the basis of its value; 10 points
~~statistics; identify type of statistics test,~~raw data, & label data; 10 points

- compare the half-life of the 6-sided dice using the preceding two figures
- compare the half-life of the 6- versus 10- sided dice using figure 1
- determine and compare decay constant using Excel's regression feature versus least squares analysis "by hand" for 6-sided dice (show screen shot of later analysis); 5 points

**resource**s

lab activity source (examples): site 1 & site 2 [access 4 / 2009]

*.xlsm (Excel VBA)

mathematica: t-test