Analyzing Franck Hertz Graph on Excel/Matlab

  • Context: MATLAB 
  • Thread starter Thread starter jenny777
  • Start date Start date
  • Tags Tags
    Graph Hertz
Click For Summary

Discussion Overview

The discussion revolves around analyzing a Franck Hertz graph using Excel or Matlab, specifically focusing on determining when the current begins to rise. Participants explore various methods for data analysis and graph interpretation in the context of a formal lab report.

Discussion Character

  • Technical explanation
  • Homework-related
  • Debate/contested

Main Points Raised

  • One participant inquires about methods to determine when the current starts to rise in their graph.
  • Another suggests using a ruler as a simple method for analysis.
  • A participant mentions needing a systematic approach as per their teaching assistant's guidance.
  • There is a suggestion to plot the gradient using Excel and identify when the increase becomes statistically significant.
  • One participant expresses uncertainty about finding the gradient and seeks clarification.
  • Another proposes using Excel to determine the best fit line and its equation, including where it crosses the x-axis.
  • Concerns are raised about the effectiveness of fitting exponential and linear lines, with one participant noting that their attempts were inaccurate.
  • A suggestion is made to plot the change in current rather than the current itself to better analyze the data.
  • Participants discuss the importance of excluding flat portions of the data to avoid misleading results.

Areas of Agreement / Disagreement

Participants express varying levels of familiarity with data analysis techniques, and while some methods are proposed, there is no consensus on a single approach or solution. The discussion remains unresolved regarding the best method to analyze the graph.

Contextual Notes

Some participants indicate limitations in their understanding of statistical significance and gradient calculation, which may affect their analysis. There is also mention of needing to exclude certain data points to improve accuracy.

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: 487
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   Reactions: 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

MATLAB Computing Sections of a Graph Which Can Be Removed By Removing Two Edges
  • · Replies 7 ·
Replies
7
Views
2K
MATLAB FEM, Matlab and the modes of an element
  • · Replies 32 ·
2
Replies
32
Views
4K
Which software to use to create this graph?
  • · Replies 3 ·
Replies
3
Views
4K
MATLAB Create Math Graph using Matlab?
  • · Replies 6 ·
Replies
6
Views
2K
MATLAB Matlab's numeric solution to det of Matrix is incorrect
  • · Replies 5 ·
Replies
5
Views
4K
MATLAB How to extract data from existing JPEG/TiFF graph?
  • · Replies 2 ·
Replies
2
Views
3K
MATLAB Getting Error When Plotting Graph (Using Python w/ matplotlib.pyplot)
  • · Replies 5 ·
Replies
5
Views
3K
MATLAB [~,~,~,~,~,~,~,~,spec] Too many output arguments...
  • · Replies 5 ·
Replies
5
Views
3K
MATLAB Working out an equation on MATLAB using co-ordinates
  • · Replies 7 ·
Replies
7
Views
2K
MATLAB Efficient Meniscus Line Detection in MATLAB - Simple and Automated Method
  • · Replies 2 ·
Replies
2
Views
2K