create a function from values

create a function from values - i have a table of values with the corresponding time and need a function i can differentiate - Messaggi

#1 Pubblicato: 27/11/2019 18:04:57
deleiman

deleiman

0 apprezzamenti in 4 post.

Gruppo: User

hi i have a table of values [R(t=60)=50965] with no obvious pattern and i need to create a function to fit into the formula
1/T = d (ln(R(t)) / dt
my thought was to make S(t)=ln(R(t)) and do d(S(t))/dt but i dont know how to turn a bunch of values into a function in smath and excel doesnt understand the function properly (i left out the last value and did auto complete and it was too far off)
HW8_Table.PNG

R(t) is in counts per second
and i am solving for T
#2 Pubblicato: 27/11/2019 18:30:00
deleiman

deleiman

0 apprezzamenti in 4 post.

Gruppo: User

Wrote

Wrote

hi i have a table of values [R(t=60)=50965] with no obvious pattern and i need to create a function to fit into the formula
1/T = d (ln(R(t)) / dt


Start by creating the Smath data table, attach in the Forum.
Your wording looks very alike fitting the laser project.
Toke > 1 month to do in Mathcad as it was so unusual.
But we had lot more data points.
Jean



HW8Q1.sm (2,45 KiB) scaricato 1164 volta(e).

do you mean like a matrix?
#3 Pubblicato: 27/11/2019 19:01:34
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

Wrote

Start by creating the Smath data table,


Before going ahead, the wiggling around the straight fit,
is it real or digitizing noise from equipment ?

Data.PNG
#4 Pubblicato: 27/11/2019 19:08:22
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

Data.sm (28,76 KiB) scaricato 1155 volta(e).
#5 Pubblicato: 27/11/2019 19:08:35
deleiman

deleiman

0 apprezzamenti in 4 post.

Gruppo: User

Wrote

Wrote

Start by creating the Smath data table,


Before going ahead, the wiggling around the straight fit,
is it real or digitizing noise from equipment ?

Data.PNG



i would be comfortable assuming it is based on the contextFile non trovato.File non trovato.
#6 Pubblicato: 27/11/2019 21:14:47
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

... in your original scale XY.

Data.sm (40,67 KiB) scaricato 1154 volta(e).
#7 Pubblicato: 27/11/2019 22:14:46
deleiman

deleiman

0 apprezzamenti in 4 post.

Gruppo: User

thank you so much
as much as i would like to say part b of the question i need to do my own homework i just couldnt understand how to get the equation of that line

thanks again
#8 Pubblicato: 28/11/2019 00:03:25
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

Wrote

thank you so much
as much as I would like to say part b of the question I need to do my own homework I just couldn't understand how to get the equation of that line


1. You mean equation of the straight red line of the first plot ?
2. Or: the piece wise linterp between the support points ?
linterp, cinterp, ainterp are built-in Smath from f(x) menu.
The straight line in [1] can be manipulated a bit from statistical methods [Not Smath built-in].
Also, if you don't like the rough bifurcation at the supports
points, easy to fillet for smooth path.
No more need for the first replies before the last attachment,
then will be removed.

Cheers ... Jean

#9 Pubblicato: 28/11/2019 01:35:47
CBG

CBG

78 apprezzamenti in 312 post.

Gruppo: User

I think you can also use the least-squares method to find the equation that best fits your data.

LSM_Eng_Stud.png

Ajust_by_Last_Square_Selection_Engineering_studente.sm (62,08 KiB) scaricato 1242 volta(e).


Best Regards

Carlos
1 utenti hanno apprezzato questo post
sergio 28/11/2019 06:00:00
#10 Pubblicato: 28/11/2019 08:55:51
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

Here is Cholesky [Least Squares], otherwise.
Ge sensor [Germanium] is an exceptional application.
Jean

Cholesky.PNG

Genfit 0 Ge SubCryogenic.sm (39,2 KiB) scaricato 1104 volta(e).
Data.sm (54,7 KiB) scaricato 1180 volta(e).
  • Nuovi post
  • Nessun nuovo post