Intermediate value of a set of array.

[HARSHAWARDHAN. S .SHASTRI]

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

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

 

[Glenn]

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

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

Maybe GROWTH()?

If I put your first four sets of data in A1:B4 and the following in C1 I get a
result of 10.78063022:

=GROWTH(B1:B4,A1:A4,3.7)

Is that what you are expecting?

 

[Bernie Deitrick]

Harshawardhan,

What you want to do is called interpolation - with your angles in column A, radii in column B, both
starting on row 2, and the value of interest (3.7) in cell C2

=PERCENTILE($B$2:$B$361,PERCENTRANK($A$2:$A$361,C2,30))

HTH,
Bernie
MS Excel MVP

 

[HARSHAWARDHAN. S .SHASTRI]

Thanks Bernie,
You are absolutely right this is a example of interpolation.Pl tell me why
you have put 30 in this formula.
Yet i have not tried this formula on my data.I will revert back after
trying.

Harshawardhan Shastri

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

 

[Bernie Deitrick]

It was a typo - 0 instead of ) ---- sorry about that. Just change it to 3, or 2, or 1.

(But 30 works - even if Excel cannot return 30 significant digits....)

HTH,
Bernie
MS Excel MVP

 

[MartinW]

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"