| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interpolating an x, y point from known x's and y's
You can use the FORECAST() function to interpolate as well as extrapolate.
See Excel Help -- Gary's Student "Steve" wrote: Hi This is probably a simple task and it is my own lack of experience in Excel -- I would like to derive a y value for an arbitrary x value from a array of known x's and known y's for some unknown function y = f(x) a la: known x, y 0.123, 4.567 0.257, 10.4567 0.4321, 20.3241 0.703, 10.345 0.804, 2.345 say I want to derive a y value for x=0.5 from this data set using a linear or higher order fit -- is there an appropriate worksheet function for this or do I have to resort to programming? Many thanks in advance. Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Interpolating an x, y point from known x's and y's | Excel Discussion (Misc queries) | |||
| Pin a callout data point | Charts and Charting in Excel | |||
| Point Assessment Calc? | Excel Discussion (Misc queries) | |||
| format inplied decimal point | Excel Discussion (Misc queries) | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
Threaded Mode
