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]

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

resources

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

*.xlsm (Excel VBA)

mathematica: t-test