Undergrad Calculating Bin Center for Rate vs Energy Plot

  • Thread starter Thread starter BillKet
  • Start date Start date
  • Tags Tags
    Bin Center
Click For Summary
SUMMARY

The forum discussion focuses on calculating the bin center for a rate vs energy plot, specifically when merging two data points with different counts and measurement times. The participants debate whether to use a simple average of the energy values or a time-weighted average for the bin center. The consensus is that merging bins should consider the statistical significance of the counts, with a recommendation to use a weighted average based on the rates and their associated uncertainties. The final formula for the energy of the merged bins is given as \(E = \frac{\sum \left(r_i E_i / \sigma_{r_i}^2\right)}{\sum \left(r_i / \sigma_{r_i}^2\right)}\).

PREREQUISITES
  • Understanding of statistical methods in data analysis
  • Familiarity with rate calculations in experimental physics
  • Knowledge of energy measurement and binning techniques
  • Proficiency in using formulas for weighted averages
NEXT STEPS
  • Study the concept of weighted averages in statistical analysis
  • Learn about error propagation in experimental data
  • Explore the implications of merging data bins in rate measurements
  • Investigate the use of statistical software for plotting rate vs energy graphs
USEFUL FOR

Researchers, physicists, and data analysts involved in experimental data analysis, particularly those working with rate vs energy plots in particle physics or similar fields.

  • #31
Events are suppose to be integers. You wave number differ by 0.000022% really.

Ok for me to proceed I have to have some confidence in this data. Can you explain exactly what and how you get this data and confirm the validity of the significant figures your present.
 
Physics news on Phys.org
  • #32
BvU said:
??

Total confusion. How do you count to 385.035301 ?
In my book 385 is followed by 386

[edit] Ah ! when you say "counts" you mean "rate" -- next time add a dimension to your data columns !

View attachment 251353

What on eart can move you to merge "bins" here ? You don't have bins, you have "energy settings".
I am sorry, yes I meant rate (to get counts multiply the first 2 columns, my bad!). Also I have few tens of thousands of points between 13252.3231 and 13293.9497 ##cm^{-1}##. Here I provided some randomly selected points just to give an example the kind of data that I have, but there is a peak when you plot everything (and you have something around 2000 counts around that freq value). So one of the reasons to merge bins, is that there might be an error associated with the freq measurement, so if I say 13252.74, if there was a miss reading, that might be actually a count belonging to 13252.75 or 13252.73. If we merge several bins, average the frequencies and quote the average as the center of the new bin (I am still not sure what kind of average would that be), we might be able to neglect that error when doing the fit. The main problem is that we know that the issue is there but we are not sure how to quantify it exactly yet. So averaging over several energies (assuming that the error goes like ##1/\sqrt(N)##) the error on each freq should be small enough such that we can ignore it. Also we are pretty sure that there is no fine structure in the peak, so doing this average should not hide some physics from us.
 
  • #33
BillKet said:
some randomly selected points
Ever see the end of the movie "A few good men" ? You could play Nicholsons role without having to audit !

Post your plot of ALL data. Counting rate vertically, cm-1 horizontally

If your counting times don't differ by more than 10%, don't even bother worrying about the effect on the error bar in individual measurements. Let alone trying to compensate.

BTW what's your energy resolution estimate ? Judging from your first two "some of the data" points it might be really good -- but by now I have trouble believing anything I read in this thread.

BillKet said:
Assuming that I want to rebin the data for some reason
Is that the lame reason 'misreading the frequency' ?

There can be no sensible argument concocted from that for rebinning. Or do you want to artificially 'improve' your observations in order to get a peak ?
 
  • #34
gleem said:
Events are suppose to be integers. You wave number differ by 0.000022% really.

Ok for me to proceed I have to have some confidence in this data. Can you explain exactly what and how you get this data and confirm the validity of the significant figures your present.
I made some clarifications in a post after, those are rates, not counts, I am sorry. So we used a laser to ionize some molecules and counted the number of ionized molecules for each laser wavelength. The laser (Ti:Sapphire)
wavelength was adjusted with a predefined schedule and when the wavelength was changed, the change was of about 0.02 ##cm^{-1}##. As I said above, we have some issues with reading the exact wavelength of the laser so 13252.7038 and 13252.7067 are probably the same value (which one of them is right, we don't know for sure), while 13252.7291 is the one after the increase by 0.02 ##cm^{-1}##. This is the raw data that we have from the software (including the decimals provided). As I said, this uncertainty about the actual freq, is the main reason why we want to do a rebinning.
 
  • #35
Don't rebin -- no reason. And show the plot -- I sure hope the peak isn't at 13252.7 :rolleyes:
 
  • #36
BvU said:
Ever see the end of the movie "A few good men" ? You could play Nicholsons role without having to audit !

Post your plot of ALL data. Counting rate vertically, cm-1 horizontally

If your counting times don't differ by more than 10%, don't even bother worrying about the effect on the error bar in individual measurements. Let alone trying to compensate.

BTW what's your energy resolution estimate ? Judging from your first two "some of the data" points it might be really good -- but by now I have trouble believing anything I read in this thread.

Is that the lame reason 'misreading the frequency' ?

There can be no sensible argument concocted from that for rebinning. Or do you want to artificially 'improve' your observations in order to get a peak ?
As I said I can't post my data. Also that peak is visible without rebinning, I am worried that the uncertainty in the freq measurement would add to the error of the actual peak center and I am not sure how to account for that yet.
 
  • #37
Wouldn't worry. Do the fit and look at the errors it comes up with. Rebinning should not affect the results and certainly shouldn't improve them.
 
  • #38
BillKet said:
I am worried that the uncertainty in the freq measurement would add to the error of the actual peak center and I am not sure how to account for that yet.

That is what we needed to know. You do need to know the uncertainty in the energy interval eventually. Why didn't set the laser to get definitively different wavelengths to start?

BillKet said:
I am worried that the uncertainty in the freq measurement would add to the error of the actual peak center and I am not sure how to account for that yet.

Yes you will need to deal with that but I agree with BvU that rebinning is not the way.
 
  • #39
gleem said:
That is what we needed to know. You do need to know the uncertainty in the energy interval eventually. Why didn't set the laser to get definitively different wavelengths to start?
Yes you will need to deal with that but I agree with BvU that rebinning is not the way.
So basically, whether the error on the freq is significant or not, rebinning will not help?
 
  • #40
You will need a reasonable estimate of the frequency uncertainty and combine it with the fitting uncertainty. As for significance it seems that you cannot determine if a change in frequency is actually a change if that is so I guess that the uncertainty would be it is close to the increment that you are making.

BillKet said:
As I said above, we have some issues with reading the exact wavelength of the laser so 13252.7038 and 13252.7067 are probably the same value (which one of them is right, we don't know for sure), while 13252.7291 is the one after the increase by 0.02 cm−1cm−1cm^{-1}.

So it looks like it is in the neighborhood of .02cm-1. Your going to have to understand your instrument and what it is telling you.
 
  • #41
I do not know what you are looking for or what you expect to see, but looking at the plot of the rate vs wave no. I see no peak only an outlier data point.
 

Similar threads

  • · Replies 37 ·
2
Replies
37
Views
5K
  • · Replies 18 ·
Replies
18
Views
3K
Replies
3
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 4 ·
Replies
4
Views
8K
Replies
8
Views
3K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 18 ·
Replies
18
Views
2K
  • · Replies 11 ·
Replies
11
Views
3K