+ Reply to Thread
Results 1 to 3 of 3

Thread: adding distributions

  1. #1
    Points: 8, Level: 1
    Level completed: 15%, Points required for next Level: 42

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    adding distributions




    Hello,
    I have a discrete distribution:
    with a chance of a delay (in hours)
    I came out of 80 000 measurements to a table with max 40 h delay and the chance of each of them occuring.
    I would like to calculate what the chance is to have less delay then 12h, 24h. When I excecute 4 times the same process with the same probablity distribution.
    Who could point me in the right direction?
    Preferably something I can handle with Excel?
    Best to fit a function?

    Thanks!

  2. #2
    TS Contributor
    Points: 12,227, Level: 72
    Level completed: 45%, Points required for next Level: 223
    rogojel's Avatar
    Location
    I work in Europe, live in Hungary
    Posts
    1,470
    Thanks
    160
    Thanked 332 Times in 312 Posts

    Re: adding distributions

    hi,
    i guess the best would be to do a simulation, that should be easy enough in Excel. Generate 4 random samples of the same (large e.g 10000) size from your original data then add the first samples from all 4, the second samples and so on and then do a histogram of the sums.

    regatds

  3. #3
    Points: 8, Level: 1
    Level completed: 15%, Points required for next Level: 42

    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: adding distributions


    thanks a lot. This was indeed quite straight forward.
    I took 4 times 50 000 points and got quite a smooth graph that stayed almost the same when the randomgenerators generated again.
    A multi million Euro decision will be taken based on this single graph

+ Reply to Thread

           




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts






Advertise on Talk Stats