Continue more complex sequence

Jaymond Flurrie

Well-known Member
Joined
Sep 22, 2008
Messages
868
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

MrExcel MVP
Joined
Jan 15, 2007
Messages
22,902
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.
 
Last edited:

Jaymond Flurrie

Well-known Member
Joined
Sep 22, 2008
Messages
868
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

MrExcel MVP
Joined
Jan 15, 2007
Messages
22,902
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.
 
Last edited:

Forum statistics

Threads
1,086,243
Messages
5,388,668
Members
402,134
Latest member
McKnze21

Some videos you may like

This Week's Hot Topics

Top