Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Approximating a curve
I have a set of X and Y values for example X Y 690 0.82 1400 1.72 2075 2.75 2760 3.93 3450 5.31 4150 6.68 4800 8.27 5500 8.34 7600 12.48 11750 8.27 14000 10.68 20000 19.51 24000 25.86 26500 28.89 28500 31.37 32500 33.3 34500 30.3 I need to calculate a value of Y for any value of X. Is there a F(x) that will allow me to do this. VLOOKUP is no good as a value of X from 20,001 to 23,999 will give the same value of Y 19.51 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
Fitting a curve similar to capacitor charging current. | New Users to Excel | |||
curve fitting a charging capacitor type curve | Excel Discussion (Misc queries) | |||
watch a curve change over time like a movie | Charts and Charting in Excel | |||
Vertical ND Curve on Combination Chart | Charts and Charting in Excel |