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 __

- 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 prelab assignment) in your simulation (show the syntax and its parameters for each Excel command; 10 points)
- 2 plots (of 6- & 10- side dice) on the same graph of __ (let time be simulated by # dice roll and # radioactive isotopes be simulated by # dice in the sample; 10 points)

- # dice versus # dice roll (use Excel's trendline --> exponential; don't include parameters of eqn & R
^{ 2})- ln (# dice) versus # dice roll (use Excel's trendline --> linear . . . feature)
- determine the half-life & decay constant for each type of dice using the preceding graph; include the basis of its value; 10 points
- determine and compare decay constant using Excel's regression feature versus least squares analysis "by hand" (show screen shot); 5 points
- statistics; identify type of statistics test, raw data, & label data; 10 points
- compare the half-life of the 6- versus 10- sided dice
- compare the decay constant of the 6- versus 10- sided dice

**resource**s

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

*.xlsm (Excel VBA)

mathematica: t-test