last day (14 days later) » 

8:59 AM
0
Q: Calculating uncertainties before aproximating exponential function

Tomáš ZatoI have a table of values that are supposed to be used as points for exponential regression (least squares method). Values in both columns are uncertain, which means that the function itself is a little uncertain as well. The rule is: $$real\ value = measured\ value \pm uncertainty$$ But how ...

 
Is this a kind of diode you're measuring the current and tension? I'm just asking out of curiosity :) Tell me if understood correctly, you want to have three curves on your graphic, the two others being the ones relatively to the addition and substraction of the uncertainty?
 
Yes, I want to combine the values so that I get the most deviant exponentials that are deemed possible. And you're right, here is the complete task. It's giving me a hard time.
 
:D , I've been there too. My school is called "école supérieure d'électricité " = " superior school of electricity", I've suffered as well on this. How do you evaluate the uncertainty? Because for a start I'd substract it to each of your measures, ask for an exponential regression on the shifted values. Now it depends how the exponential regression is implemented. Is it automatic or do you have to plot th log of your values and get a straight line?
 
I'm plotting it using internet calculators. Here is a plot where red comes from smallest possible values, red comes from largest.
 
Ok I've read your post of physics.stackexchange, I think you got what you wanted essentially. $ \alpha$ is your coefficient $\frac{e}{kT}$, so you can get your boltzmann constant (k). Do that for each of your curves (measured, -uncertainty, +uncertainty), you will get three values of k from which you will get the uncertainty on k. Is it what you were looking for?
 
8:59 AM
That't the problem - is -uncertainty really the most extreme deviation from measured when the function is plotted? If you look on the graph, the red is almost the same as green - the deviation is quite asymmetric. If I had more time, I could probably let Matlab plot all the combinations of +-uncertainty to find the most deviated functions.
Would you help me in chat?
If we figure out the solutions, you can post it as an answer...
 
Ok so the question is: can we find a certain order of addition and substraction of uncertainty ( substract uncertainty to the first measure, add it to the next, and the following one, then substract to the fourth measure, etc... for instace) such as the deviation from the regression did on the untouched measures is the largest possible? And is it: always substract uncertainty, or always add it?
 
Yes, you phrased it perfectly
How would you figure it out?
It could be even +Ampers -Volts
 
What was the yellow plot on your last graphic ? and the green one?
 
green was the measured values plot
red is -uncertainty
yellow is +uncertainty
 
9:23 AM
Ok, I'd rather use a linear regression with the ln of the relation existing between I and U :

ln(I/A) = b*U (alpha is too long to write)
Question is: how to minimize or maximize the coefficient b? That's what'll give you your most deviated functions.
Then I think what is the most deviated way of injecting uncertainty is:
you want to maximize b => maximize I and minimize U : +A , -V
you want minimize b => minimize I and maximize U : -A , +V
What do you think?
Maybe it's a bit naive, I could try to refine it with optimization methods but i don"t have my course with me and don't remember all of it very well.
 
That's a good thinking
I'll run a pracal test
 
I'll post it as an answer, and if I come up with a more sophisticated and less handmade solution I'll edit the post :)
 
The orange deviation is the +A -V
http://fooplot.com/#W3sidHlwZSI6MywiZXEiOltbIjAuMzMyIiwiMC4wMDE0Il0sWyIwLjUwNDUiLCIxLjk5OTgiXSxbIjAuNTA3MiIsIjIuMjA4Il0sWyIwLjUxNzciLCIzLjMxNyJdLFsiMC41MjY2IiwiNC43NCJdLFsiMC41MzM5IiwiNi4yNDciXSxbIjAuNTM5OSIsIjcuODU2Il0sWyIwLjU0NDYiLCI5LjQiXSxbIjAuNTQ4NSIsIjEwLjg4OCJdLFsiMC41NDg4IiwiMTEiXSxbIjAuNTUxOSIsIjEyLjM4NiJdLFsiMC41NTYxIiwiMTQuNDIxIl0sWyIwLjU1OTQiLCIxNi4yMTEiXSxbIjAuNTYxIiwiMTcuMTEiXSxbIjAuNTYyOSIsIjE4LjEwNyJdLFsiMC41Njc0IiwiMTkuODE0Il1dLCJjb2xvciI6IiMwMzAzMDMifSx7InR5cGUiOjAsImVxIjoiMi4wNjQ4ODAyNDkqMTBeKC04KSplXigzNi41NzgwMzQwNCp4KSIsImNvbG9yIjoiIzI
It's not extreme, since it has intersections with other plots
 
9:44 AM
I know why
it's because there is an offset, and the coefficient A is negative
The relation is more like : I = $I_o -A*exp(bI) $

so in fact you should consider : +A, +V to maximize b
ah, formatting doesn't work ..
 
I can see it :)
 
No sorry :
I = Aexp(-b*I)
I = Aexp(-b*U) sorry
So you have : ln(I/A) = -b*U
No forget it, it's just that the A coefficient is very small
 
10:02 AM
I invested some time and tested all combinations: +A +U, +A -U, -A +U, -A -U
 
But that's curious, it should work nonetheless.. So yellow is when you add the uncertainty to both I and U ?
 
Wait, I'll send new graph
It's too long for a message
The graph: goo.gl/febz9E
The sources can bee seen here: docs.google.com/spreadsheets/d/…
 
I'm trying this on regular linear relations: you draw little squares around each point (that's your two dimensional uncertainty) and you can tell visually that when you choose the upper left side of the square you get the most positively deviated regression
 
Scroll left
*right
As you can see all combinations eventually intersect
Green comes from original data
 
yes :) , but I believe the exponential regression used by your site doesn't suppose that A the factor is constant, while I did
that's why we don't make sense :)
That's also why they intersect
 
10:08 AM
But how can I know the A factor to make it constant?
I think you're few steps ahead of me
 
That's something else, like other constants in your equation you only evaluate one parameter at the time - An unknown error has occurred
forget the end of my post, I had an error while posting it
you could look for a measure of the residual current when U is very small
that'll give Io, since the exponential will be assimilated to 1 if you combine things correctly when taking into account the actual values of e, k , and T( assume 20° celsius, sorry I'm french :) )
Now when you have a good value of Io, you can settle it and start studying k, if you know the value of e, and the temperature
 
I'm czech, we're using the same units
 
ah ok, nice
 
I also speak french a little
 
I don't mind speaking english, but I don't speak czech at all sorry :)
 
10:16 AM
I'll ask my teacher to explain this tomorow. I'll then share it here.
 
ok ok, I'm not sure I've been very clear
 
Frankly, no, I'm not good at math
I'll need it repeated several times before I get it.
I'll read this conversation few times
 
it's just that when you want to to evaluate a parameter in an equation that contains several, you need to settle all other parameters, or else you won't get anything straight
It's the easiest way of doing this kind of stuff
Do you want me to edit my answer?
 
No, let's keep it. I'll let you know tomorow. If you're right, I'll accept it and upvote it.
Sorry for the delay, but I can't figure it so fast
Don't worry, I won't forget :)
 

last day (14 days later) »