"Trend" Function

[andy duncan]

I have posted a message asking about the extrapoloation of Data - Perhaps
Trend is usable instead ?

Can TREND be used for non Linear data ?
As I have mentioned earlier: "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.

Would trend allow this or are there better ways of doing this ?


Cheers Andy

 

[Bernd P]

Hello Andy,

I suggest to interpolate:
http://www.sulprobil.com/html/interpolate.html

Your data looks "linear"...

Regards,
Bernd

 

[andy duncan]

Bernd,

Cripes that loks a touch complicated !
I assume I have to use VB editor to insert / create a new function as shown?

Andy

 

[Jerry W. Lewis]

While FORECAST is limited to simple linear regression, TREND can give you
predicted values from multiple regression.

Jerry

 

[Bernd P]

Hello Andy,

It is not that complex:

In Excel, press ALT + F11, enter a new module, copy my macro text into
this new module and go back to your worksheet.

Should work...

Regards,
Bernd