Hello,(adsbygoogle = window.adsbygoogle || []).push({});

I am a PhD student in geology in need of help from a physicist! Can somebody spot the mistake in my spreadsheet?

I am using an Excel spreadsheet (attached .xls) to integrate the Bethe formula in order to estimate the range (in cm) of alpha particles in quartz. I am using the version of the formula given in Groom and Klein's "Passage of Particles through Matter": http://pdg.lbl.gov/2009/reviews/rpp2009-rev-passage-particles-matter.pdf (but ignoring the density effect correction because I am not interested in high energies).

In Excel, I can plot the Bragg peak (dE/dX against x) or the energy of the alpha particle (E against x). Something is very wrong: the Bragg curve just goes up and up and never comes down again (don't be misled by Excel plotting #NUM! as 0). I would expect dE/dX to start out at something like 500 and then smoothly increase up to the peak (like the Bragg peaks in Google image search).

I must be doing something right, though, because it looks as if the stopping distance is going to be close to what I would expect (about 0.04 cm).

Can anybody find the problem in the attached spreadsheet? Reward: credit in my thesis acknowledgements!

Many thanks!

Moho

**Physics Forums | Science Articles, Homework Help, Discussion**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Numerical integration of Bethe formula in Excel: help!

Loading...

Similar Threads for Numerical integration Bethe |
---|

A Feynman integral with three propagators |

I Analytically continuing 2,3,4pt integrals |

I Peskin book on QFT question -- 2 integrals for D(x−y) |

**Physics Forums | Science Articles, Homework Help, Discussion**