Say I have in column A this:

23
34
56
27
18
32
24

What and how excel function would I use to predict the next value?

Thanks,
Jo

Forecast for a linear estimate

with your data in A1:A7

=FORECAST(8,A1:A7,{1,2,3,4,5,6,7})

gives me 25.

You can also look as Linest and Logest and Growth.



You can graph your data and fit a trend line of choice.

I graphed it and it looks pretty irregular to me.

Information on using LINEST for a polynomial fit:
http://www.stfx.ca/people/bliengme/E...Polynomial.htm

--
Regards,
Tom Ogilvy




--
Regards,
Tom Ogilvy


"Jo" wrote:

Say I have in column A this:

23
34
56
27
18
32
24

What and how excel function would I use to predict the next value?

Thanks,
Jo