Determine the half lives of two radioisotopes

Click For Summary
SUMMARY

This discussion focuses on determining the half-lives of two radioisotopes in a neutron-activated copper sample using Excel. The user, Ben, employed the ln(activity) vs. time plot and the LINEST function to derive decay functions for both isotopes. A minimum chi-squared value was calculated using Excel's Solver to optimize the fit, but Ben faced challenges in quantifying the error on the fitted function due to Poisson error. Suggestions included using a weighted least squares method and Monte Carlo simulations to better account for uncertainties in the data.

PREREQUISITES
  • Understanding of radioisotope decay and half-life concepts
  • Proficiency in Excel, specifically with the LINEST function and Solver tool
  • Knowledge of statistical methods, particularly chi-squared analysis
  • Familiarity with Poisson error and its implications in data analysis
NEXT STEPS
  • Research weighted least squares regression techniques
  • Explore Monte Carlo simulation methods for error analysis
  • Study advanced statistical methods for fitting functions to experimental data
  • Learn about Poisson distribution and its application in experimental physics
USEFUL FOR

Researchers and students in nuclear physics, data analysts working with experimental data, and anyone involved in statistical modeling of radioactive decay processes.

robbo157
Messages
1
Reaction score
0
Hi,

I am trying to determine the half lives of two radioisotopes in a neutron activated sample of copper. I have plotted the the ln(activity) vs. time and then used the linest function on excel to get a decay function for the longer half-life by assuming after a certain time, only the longer halflife isotope would contribute. This was then subtracted from the total activity and thus a value for the shorter halflife component could be determined through the linest function again. A minimum chi squared value was found through 'solver' on excel by altering the constants in this fitted function. Because I am fitting a hypothesis to data each chi squared component will be (observed count rate - fitted function rate)^2/fitted function rate. This then produced the best possible function to fit the data. The problem with determining the error on this function is: how does the poisson error of +-sqrt(N) on each data point affect the error on the fitted function?
I have tried settin the minimum chi squared to +1 its original value but this gives very small error values as might be expected...

Any help on this could well save my life.

Thanks,
Ben
 
Physics news on Phys.org


Hi Ben,

Thank you for sharing your approach and concerns regarding determining the half-lives of two radioisotopes in a neutron activated sample of copper. It seems like you have taken a thorough and well-thought-out approach to your analysis. However, as you mentioned, the main issue lies in determining the errors on your fitted function.

The poisson error on each data point, as you pointed out, can greatly affect the error on the fitted function. One way to account for this is to use a weighted least squares method, where the weight of each data point is taken into consideration in the calculation of the errors. This can be done by multiplying the chi squared values by the inverse of the square of the poisson error for each data point. This will give more weight to data points with smaller errors and less weight to data points with larger errors.

Another approach could be to use a Monte Carlo simulation, where you generate multiple sets of data points based on the original data and their poisson errors, and then fit a function to each set. The errors on the fitted function can then be determined from the spread of the fitted function values from the different sets of data. This method takes into account the uncertainties in the data points and can give a more accurate estimate of the error on the fitted function.

I hope these suggestions can help you in determining the errors on your fitted function. Good luck with your analysis!


 

Similar threads

  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 13 ·
Replies
13
Views
3K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 6 ·
Replies
6
Views
24K
  • · Replies 3 ·
Replies
3
Views
5K
Replies
4
Views
4K
  • · Replies 9 ·
Replies
9
Views
6K
  • · Replies 3 ·
Replies
3
Views
42K