Hi Harshawardhan,

Just thinking out loud here.

It looks like you are trying to calculate to the nice
smooth curve that excel provides in an XY chart.

Unfortunately that line is not produced wholly by mathematical
formulae but by computer tricks. It calculates a straight
line fit between the points and then applies a smoothing
effect with anti-aliasing.

It may be possible to calculate to that line but you would
need to be able to isolate the tangent points for each part
of the curve and then calculate the mid-ordinate for each
individual curve. Tricky but there may be possibilities.

Please post a more complete example of the data set.

HTH
Martin


"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Actually i have raised this query about 2 years back in same forum but
still i have not got satisfactory solution.

What i looking for is ,

I am having a data for cam profile. data is in angle and radius which
may
looks like

angle radius

1 10
2 10.3
3 10.6
4 10.85
. .
100 32


359 10.3

What i need is intermediate value of radius, say at angle 3.7 degrees.

I am having total 360 readings at interval of 1 deg.

Harshawardhan Shastri

================================================== ======