Forecasting

[praetorian]

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]

I persume you are comparing months July,Aug,sept

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

Rob

[Paul_Hossler]

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]

Thank you both.

[praetorian]

Again, thank you. It looked pretty close. Appreciate it.