Forecasting Monthly Expenditures Using Normal Distribution in Excel

[physics911]

Hi, everyone,

I have a quick question for normal distribution in Excel.

There's a construction project with the following monthly expenditures:

JUL 2008 $ 4,903
AUG 2008 $ 3,591
SEP 2008 $ 15,452
OCT 2008 $ 12,806
NOV 2008 $ 59,988
DEC 2008 $ 121,808
JAN 2009 $ 261,162
FEB 2009 $ 264,769
MAR 2009 $ 306,240
APR 2009 $ 438,695
MAY 2009 $ 397,569
JUN 2009 $ 345,190


The project's allocated amount is $12 million and the time period is from July 2008 to December 2010. Is there anyway I can forecast future monthly expenditures (from July 2009 & onwards) based on normal distribution model using Excel 2003?

Your input is greatly appreciated.

Thank you.

Physics911

 

[uart]

Do those costs look normally distrubuted to you?

I think you'd do better to approach it from a linear regression point of view.BTW. This looks like homework. Is it?