Please see the attached two curves which i want to transfer to excel to automate my
calculations, i made a try in the attached workbook and i need your advice and comments
for the first curve
having t,x i got y
now, is what i have done is true and accurate (using the linear equation) or there a best fit polynomial or other way to do that
I tried LINEST on the rows A3 to A8 if i complete to A33 will it differ or be more accurate
if i have t=12 (or any value between 0,30 which have no exact values on the attached curve) and x =14.5 for example how can i interpolate to find y
with the same x i got y in the curve in the second sheet
is my polynomial is accurate , is there a better way
thanks in advance
Bookmarks