Need help finding a pattern in the columns of numbers?

Question

http://spreadsheets.google.com/pub?key=pz020dnvNJF-AXa_8PsplKA each column in the spreadsheet is its own set of numbers, i need help figuring out the pattern or some kind of formula that would get me the next number going, it goes from bottom being oldest to the top being the newest number

Answer 1

The simplest way is to use a moving average to predict the next number.

Let X_k be your series, k=0...N

Let M_k = average over X_k-n up to X_k (the last n terms)

Let P_k+1 = X_k + (M_k-M_k-1) the prediction of the next term.

More sophisticated schemes apply this idea not only on the terms itself but also on a number of derivatives.  

Here is a starting point to more info:

http://en.wikipedia.org/wiki/Time_series...