PDA

View Full Version : Forecasting



praetorian
08-05-2011, 07:57 AM
Hello,

How can I make a forecast for the last three months of FY 11 based on the prior years? I've attached a sample sheet with the data.

Thank you in advance.

Rob342
08-06-2011, 10:06 AM
I persume you are comparing months July,Aug,sept

=Sum(B11:C11)/2
So D11 = 1,346,200.00

Rob

Paul_Hossler
08-06-2011, 10:36 AM
Been a L-O-O-N-G time since I've done any real statistics

Two versions, one with seasonal adjustments and one without

Both use FORECAST()

A quick Google for Excel Seasonal Forecast finds a lot, I put 2 links in the attachment

I did make the Month and FY into real Excel dates

Paul

praetorian
08-06-2011, 12:42 PM
Thank you both.

praetorian
08-06-2011, 10:51 PM
Again, thank you. It looked pretty close. Appreciate it.