Statistics of Radioactive Decay

AI Thread Summary
The discussion revolves around using a Geiger-Muller counter to measure natural radioactivity and analyzing the data collected. The user successfully plotted the counts in Excel, resulting in a Gaussian-like curve but struggles to create an accurate best fit curve. Suggestions for resolving this issue include using the NORMDIST function in Excel to achieve a better fit. The user reports that this approach seems to have worked. The conversation highlights challenges in data analysis and the application of statistical functions in Excel.
theuniverse
Messages
53
Reaction score
0

Homework Statement


I hope that I'm posting it in the right section...
I did an experiment in class using a Geiger-Muller counter with the objective to find the amount of counts (how many photons hit the detector) due to natural radioactivity around my work station. I recorded 45 values of counts from the GM counter, and then created a table which shows how frequently each count appeared in the 45 measurements.

I put the values in a spreadsheet in excel and plotted a scatter graph of my values, and as expected I got a curve that resembles a Gaussian Curve, but now my problem is that I don't know how to make a best fit curve to these points, and whenver I try to use the functions of excel I get some curve of average that changes the shape of the curve completely.

How can I create a best fit curve to this data?

Homework Equations

The Attempt at a Solution


Excel file attached.

Thank you for your time.
 

Attachments

Physics news on Phys.org
Try the NORMDIST function is Excel.
 
Thanks! seems to work now.
 
I multiplied the values first without the error limit. Got 19.38. rounded it off to 2 significant figures since the given data has 2 significant figures. So = 19. For error I used the above formula. It comes out about 1.48. Now my question is. Should I write the answer as 19±1.5 (rounding 1.48 to 2 significant figures) OR should I write it as 19±1. So in short, should the error have same number of significant figures as the mean value or should it have the same number of decimal places as...
Thread 'A cylinder connected to a hanging mass'
Let's declare that for the cylinder, mass = M = 10 kg Radius = R = 4 m For the wall and the floor, Friction coeff = ##\mu## = 0.5 For the hanging mass, mass = m = 11 kg First, we divide the force according to their respective plane (x and y thing, correct me if I'm wrong) and according to which, cylinder or the hanging mass, they're working on. Force on the hanging mass $$mg - T = ma$$ Force(Cylinder) on y $$N_f + f_w - Mg = 0$$ Force(Cylinder) on x $$T + f_f - N_w = Ma$$ There's also...
Back
Top