"november678x" <november678x.27lowz_1147279503.7596@excelforum-nospam.com>
wrote in message
news:november678x.27lowz_1147279503.7596@excelforum-nospam.com...
>
> Hello to all,
>
> Does anyone know how I can forecast the 4th quarter amount for the data
> below? I tried using the linear trend on my chart and selected 3 future
> periods under the trend line options. This showed me a future trend but
> it did not display what the totals will be. Any help would be
> appreciated.
>
> Thank you
>
>
> Q1 - 2500
>
> Q2 - 2350
>
> Q3 - 2475
>
> Q4 - ?

Use the LINEST() function, which will calculate the parameters of your
y=mx+c linear fit. Having calculated the parameters, you can then evaluate
the value of y for any x. In your case, for Q4, y comes to 2416.667. [You
can of course plot this, to show it agrees with the trend line that Excel
plotted for you.]
--
David Biddulph