View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Extrapolation of non linear data

Do you mean that you want to have your Soundings to start at 0.7 and
increase in 0.1 increments to, say, 8.0, and for each of these values
you want to extrapolate between the appropriate pairs of data in your
original table (i.e. data on either side of the new soundings
increment)?

If so, I'll have a look at it later on.

Pete

On Aug 1, 3:33 pm, "andy duncan"
wrote:
I think I can reach my goal but with many complicated steps - all probably
summarised in a simple function !

I have two columns of data :
Soundings, Mass :
0.000 0.000
0.772 65.750
1.335 129.640
1.897 198.700
2.460 271.350
3.022 346.640
3.585 424.020
4.147 503.130
4.710 591.880
5.272 695.640
5.835 800.290
6.397 905.730
6.960 1011.760
7.522 1118.300
8.085 1133.090

the iterations of my known column of data, (the soundings), is first 0.7 and
therafter 0.3.

I need to examine the data to increments of 0.1, and hence spread it out
over far more iterations.

Any good ways of doing this that you know of ?

Cheers Andy