LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Which trend line? joyous_h New Users to Excel 1 July 25th 06 01:32 PM
Getting values from a trend line Andrew Excel Discussion (Misc queries) 3 February 22nd 06 06:27 PM
Trend line AndreasN Charts and Charting in Excel 2 February 12th 05 07:37 PM
trend line does not appear JB Charts and Charting in Excel 1 January 26th 05 08:24 PM
trend line Nee Charts and Charting in Excel 2 January 25th 05 03:11 PM


All times are GMT +1. The time now is 06:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"