Continue more complex sequence

[Jaymond Flurrie]

Everyone knows Excel can continue 1,2,3... to 4,5,6 and Monday, Tuesday, Wednesday to Thursday, Friday, Saturday. But what if the sequence is much more complex? Like for example, given list:
10
6,025
3,77
2,52
1,77
1,32
1,01
0,805
0,645
0,53
give me the 50th entry on that list. What's the function? That's exactly what I'm asking for.

 

[mikerickson]

Unless you know how the sequence progresses, Excel can't predict the future values.

 

[Jaymond Flurrie]

Unless you know how the sequence progresses, Excel can't predict the future values.

I kind of thought so - I probably need something more mathematical oriented program for that. Thanks for confirming though!

 

[mikerickson]

Unless you know that a sequence is a particular type, ("linear", "logrhythmic", or ....), taking 10 numbers and trying to extrapolate the 50 is not likely to be accurate. In any program.

 

[Jaymond Flurrie]

Unless you know that a sequence is a particular type, ("linear", "logrhythmic", or ....), taking 10 numbers and trying to extrapolate the 50 is not likely to be accurate. In any program.

But I think it can give with some accuracy. I can get more of those numbers to that list of known values too.

 

[mikerickson]

Many data points are good for finding intermediate values, not for extrapolating the future unless (as stated above) the nature of the data collected tells one what kind of function the data is likely to follow.

BTW, you don't need to quote a post that you are immediately responding to, it just eats up screen space.