If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Intermediate value of a set of array.
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 ================================================== ====== |
#2
|
|||
|
|||
Intermediate value of a set of array.
HARSHAWARDHAN. S .SHASTRI wrote:
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? |
#3
|
|||
|
|||
Intermediate value of a set of array.
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" wrote in message news 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 ================================================== ====== |
#4
|
|||
|
|||
Intermediate value of a set of array.
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" wrote: 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" wrote in message news 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 ================================================== ====== |
#5
|
|||
|
|||
Intermediate value of a set of array.
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 "HARSHAWARDHAN. S .SHASTRI" wrote in message ... 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" wrote: 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" wrote in message news 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 ================================================== ====== |
#6
|
|||
|
|||
Intermediate value of a set of array.
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 news 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 ================================================== ====== |
Thread Tools | |
Display Modes | |
|
|