- #1
jenny777
- 28
- 0
Hello,
I'm writing my lab report for my Franck Hertz oscillation and I seem to be stuck on analysis part where I have to perform auto-correlations.
Could anyone please guide me through steps 2-4 on excel? I absolute have no idea what the steps 2-4 is asking me to do. For instance, for step 2 I don't understand how i can get a least squares fir for my maxima and minima only. I really appreciate any sort of help
I've included a picture of my graph
Step 2:
Do a least squares fit to the data (location of maxima and minima), and record the values
of the slope and intercept and their uncertainties. (Note that the zero point may not be zero
because of an offset voltage in the data, the contact potential). You may have time to do this
before you leave the lab, as well.
Step 3:
Subtract the value of the best-fit line from your original data. Provide a graph containing
the values before and after subtraction.
Step 4:
Perform an auto-correlation for 10 delays centered on the voltage nearest the wavelength
estimate derived above. Record these values and plot them on a graph. Show intermediate work
for at least one non-zero delay calculation.
I'm writing my lab report for my Franck Hertz oscillation and I seem to be stuck on analysis part where I have to perform auto-correlations.
Could anyone please guide me through steps 2-4 on excel? I absolute have no idea what the steps 2-4 is asking me to do. For instance, for step 2 I don't understand how i can get a least squares fir for my maxima and minima only. I really appreciate any sort of help
I've included a picture of my graph
Step 2:
Do a least squares fit to the data (location of maxima and minima), and record the values
of the slope and intercept and their uncertainties. (Note that the zero point may not be zero
because of an offset voltage in the data, the contact potential). You may have time to do this
before you leave the lab, as well.
Step 3:
Subtract the value of the best-fit line from your original data. Provide a graph containing
the values before and after subtraction.
Step 4:
Perform an auto-correlation for 10 delays centered on the voltage nearest the wavelength
estimate derived above. Record these values and plot them on a graph. Show intermediate work
for at least one non-zero delay calculation.