Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I have two sets of numbers and I need to be able to interpolate very accurately the numbers I dont know for the A column not al lof them just say 680 for example. What would the corresponding B colum number be?. A 270 370 409 440 550 555 640 (new number in series) 740 850 B 411 288 264 236 210 205 XXX (Unknown) 153 131 I have tried linear regression and it doesent work, probably because the second set of numbers decrease as the first set increase. Any advice greatly appreciated. Cheers, Aaron. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Which trend line? | New Users to Excel | |||
Getting values from a trend line | Excel Discussion (Misc queries) | |||
Trend line | Charts and Charting in Excel | |||
trend line does not appear | Charts and Charting in Excel | |||
trend line | Charts and Charting in Excel |