1. Limited time only! Sign up for a free 30min personal tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Normal Distribution for Excel

  1. Aug 17, 2009 #1
    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
     
  2. jcsd
  3. Aug 18, 2009 #2

    uart

    User Avatar
    Science Advisor

    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?
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Normal Distribution for Excel
  1. Normal Distributions (Replies: 4)

Loading...