MATLAB Analyzing Franck Hertz Graph on Excel/Matlab

  • Thread starter Thread starter jenny777
  • Start date Start date
  • Tags Tags
    Graph Hertz
Click For Summary
To determine when the current starts to rise in a graph for a Franck-Hertz oscillation lab report, users can utilize Excel or MATLAB for analysis. A systematic approach involves plotting the gradient of the current measurements rather than the current itself. This can be achieved by calculating the change in current divided by the change in the input variable, effectively creating a gradient plot. Users are advised to exclude data points from the flat portion of the graph to avoid skewed results. Additionally, fitting a trend line in Excel can help identify the best fit and provide the equation of the line, including its intersection with the x-axis. If initial attempts at fitting exponential or linear lines are unsuccessful, refining the data selection and focusing on the relevant rising portion of the curve is crucial for accurate analysis.
jenny777
Messages
28
Reaction score
0
Hello,

How can I determine when the current is starting rise? What methods should I use to do so? on excel or matlab.

I've attached an image of my graph below

Thanks a million
 

Attachments

  • curve.jpg
    curve.jpg
    10.3 KB · Views: 474
Physics news on Phys.org
Er, can you use a ruler?
 
that's what I did on my last lab, for Planck's constant, but apparently I need some systematic way of determining it according to my TA
 
I'm writing a formal lab report for Franck Hertz oscillation
 
Can you plot the gradient using Excel. Then if possible say when the increase in the gradient becomes statistically significant?
 
how do I find the gradient? (sorry I'm not really good at this)
 
Or may get Excel to determine the best fit line. It will tell you the equation of the line and where is crosses the x axis.
 
If you don't know how look up trend lines in Excel help.
 
I tried fitting an exponential and linear line, but it didn't work. it was way too off. But why would the would I be looking for a y-intercept of the line? (where it crosses the origin)
 
  • #10
oops, i meant to say why would I be, not why would the would I ...haha
 
  • #11
jenny777 said:
how do I find the gradient? (sorry I'm not really good at this)

Rather than plot the current, you could plot the change in the current. That would be the change in each current measurement divided by the each little change in your input variable. That would be the gradient.
 
  • Like
Likes 1 person
  • #12
jenny777 said:
I tried fitting an exponential and linear line, but it didn't work. it was way too off. But why would the would I be looking for a y-intercept of the line? (where it crosses the origin)

Sorry, I meant the x axis. And you can't use all the points - you need to exclude the flat part, else you will get rubbish.
 
  • #13
I think the gradient plot sounds good! thanks so much!
 

Similar threads

Replies
7
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 32 ·
2
Replies
32
Views
4K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 5 ·
Replies
5
Views
2K
  • · Replies 7 ·
Replies
7
Views
2K
  • · Replies 4 ·
Replies
4
Views
2K