On Jun 29, 12:22 am, Aaron wrote:
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.

I have also tried plotting it with word as an xy graph in word, and
the best trendline is the 3 polynominal exponential line.

How do I use this forula in excel to make a missing data formula.

Cheers,

Aaron.