ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Xtrapolation of Data (https://www.excelbanter.com/excel-worksheet-functions/152593-xtrapolation-data.html)

Andy

Xtrapolation of Data
 
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 every 0.7 or 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 ?




Jerry W. Lewis

Xtrapolation of Data
 
Please be patient and don't repost the same question repeatedly.
Knowledgeable people will see your question when they see it. Multiple
posting merely fragments the thread.

Jerry

"Andy" 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 every 0.7 or 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 ?


andy duncan

Xtrapolation of Data
 
Jerry,

Apologies - honest mistake.

I did not realise that the discussion group done live on the internet
through Internet Explorer was linked to the discussion group I access
through Outlook Express.

Andy

"Jerry W. Lewis" wrote in message
...
Please be patient and don't repost the same question repeatedly.
Knowledgeable people will see your question when they see it. Multiple
posting merely fragments the thread.

Jerry

"Andy" 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 every 0.7 or
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 ?





All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com