Forecasting...

guinness123

New Member
Joined
Mar 26, 2011
Messages
2
Hey relative newbie to excel and stumped! I have a trendline forecasting question that I have no idea how to solve...

I have a group of stats for 4 years:

2006 - 327
2007 - 337
2008 - 325
2009 - 332

I need to find a baseline (average of the 4 years) in order to plan a 25% reduction by 2015.
I though I could use excel using a trendline?!
I have looked to maybe change the trendline equation substituting the "x" for the year...
Any help would be greatly appreciated!
:confused:
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,278
Hi and welcome.

You could use the FORECAST function to calculate a linear forecast.
Excel Workbook
ABCDEF
12006327YearForecast-25%
220073372015332.5249.375
32008325
42009332
Sheet
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,487
Messages
5,529,162
Members
409,851
Latest member
Ingar
Top