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 Опубликовано: 27.11.2019 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 Опубликовано: 27.11.2019 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 КиБ) скачан 26 раз(а).

do you mean like a matrix?
#3 Опубликовано: 27.11.2019 19:01:34
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: 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 Опубликовано: 27.11.2019 19:08:22
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

Data.sm (28 КиБ) скачан 33 раз(а).
#5 Опубликовано: 27.11.2019 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 Опубликовано: 27.11.2019 21:14:47
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

... in your original scale XY.

Data.sm (40 КиБ) скачан 32 раз(а).
#7 Опубликовано: 27.11.2019 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 Опубликовано: 28.11.2019 00:03:25
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: 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 Опубликовано: 28.11.2019 01:35:47
CBG

CBG

77 сообщений из 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 КиБ) скачан 39 раз(а).


Best Regards

Carlos
1 пользователям понравился этот пост
sergio 28.11.2019 06:00:00
#10 Опубликовано: 28.11.2019 08:55:51
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

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

Cholesky.PNG

Genfit 0 Ge SubCryogenic.sm (39 КиБ) скачан 39 раз(а).
Data.sm (54 КиБ) скачан 35 раз(а).
  • Новые сообщения Новые сообщения
  • Нет новых сообщений Нет новых сообщений