View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aaron Aaron is offline
external usenet poster
 
Posts: 59
Default Forming a trend line

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.