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 - 消息

#1 已发布: 2019/11/27 18:04:57
deleiman

deleiman

0个赞,共4个帖子。

组: 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 已发布: 2019/11/27 18:30:00
deleiman

deleiman

0个赞,共4个帖子。

组: 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)已下载 1176 次。

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

Jean Giraud

983个赞,共6,866个帖子。

组: 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 已发布: 2019/11/27 19:08:22
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

Data.sm (28.76 KiB)已下载 1163 次。
#5 已发布: 2019/11/27 19:08:35
deleiman

deleiman

0个赞,共4个帖子。

组: 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 context未找到文件。未找到文件。
#6 已发布: 2019/11/27 21:14:47
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

... in your original scale XY.

Data.sm (40.67 KiB)已下载 1165 次。
#7 已发布: 2019/11/27 22:14:46
deleiman

deleiman

0个赞,共4个帖子。

组: 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 已发布: 2019/11/28 00:03:25
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: 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 已发布: 2019/11/28 01:35:47
CBG

CBG

78个赞,共312个帖子。

组: 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)已下载 1254 次。


Best Regards

Carlos
1位用户喜欢此帖子
sergio 2019/11/28 06:00:00
#10 已发布: 2019/11/28 08:55:51
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: 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)已下载 1119 次。
Data.sm (54.7 KiB)已下载 1190 次。
  • 有新帖
  • 无新帖