Statistics of Radioactive Decay

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.
 

Similar threads

  • · Replies 5 ·
Replies
5
Views
3K
Replies
12
Views
2K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 1 ·
Replies
1
Views
2K
Replies
3
Views
2K
  • · Replies 7 ·
Replies
7
Views
3K
Replies
4
Views
2K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 1 ·
Replies
1
Views
2K