+ Reply to Thread
Results 1 to 6 of 6

calculating inter arrival times and statistical distribution of these times

  1. #1
    Registered User
    Join Date
    03-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    3

    calculating inter arrival times and statistical distribution of these times

    data analysis2.xlsxdata analysis2.xlsx

    Hello,

    As per attached file you can see i have two colums of data.
    collum 1: all dates of incoming trucks on a production site
    collum 2: times of arrival of these trucks.

    For my thesis, I want to know how the inter arrival times are for these incoming trucks.
    But I want also want to know the statistic distribution of these inter arrival times.
    So are these arrival times when I put them in like classes or slots normally distributed or exponential ?


    Could anybody help me out how I can calculate this en let this see in a histogram of some sort ?

    I know this is very large questions, but have been breaking my head on this for 7 days now.

    Kind regards and many thanks in advance

    Ditmar

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: calculating inter arrival times and statistical distribution of these times

    What do you mean by "inter arrival times"?
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    03-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: calculating inter arrival times and statistical distribution of these times

    time between each arrival of every truck

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: calculating inter arrival times and statistical distribution of these times

    With the formulas, the file gets too big to post as an attachment here, so I loaded it here:

    https://onedrive.live.com/redir?resi...t=file%2c.xlsx

    I wasn't sure how you wanted to handle day-to-day, so I used the formula
    =IF(A2=A1,B2-B1,"")
    If you want to ignore day and look at 24 hour operation, just change that to
    =(A3+B3)-(A2+B2)
    in cell C3, and delete the formula in B2.
    Last edited by Bernie Deitrick; 03-17-2014 at 11:22 AM.

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: calculating inter arrival times and statistical distribution of these times

    Nicely done, Bernie.

    For histogram purposes, I'd remove the 0 as the first bin; it counts only the values that are exactly 0, as opposed to all the others.

    A power series is a decent fit, but a Poisson regression is probably the ticket. The values of 0 for the interarrival times seem a little sketchy, though.
    Last edited by shg; 03-17-2014 at 12:02 PM.
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Registered User
    Join Date
    03-17-2014
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: calculating inter arrival times and statistical distribution of these times

    Thank you very much for the quick and very good help. This is very helpfull.

    Greetings from Holland.

    Ditmar
    Last edited by ditmar.rijk; 03-19-2014 at 03:20 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. If a search term can be found 1 time, 2 times 3 times 4 times 5 times
    By excelcandy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 09:57 PM
  2. [SOLVED] Calculating the number of people in building based on arrival and departure times
    By dvs in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-01-2012, 09:45 AM
  3. how to subtract date and time to get inter-arrival time
    By whattodo in forum Excel General
    Replies: 1
    Last Post: 05-28-2012, 12:38 AM
  4. VBA Inter-arrival Times, LOTS OF DATA, $ for help!
    By ath1337 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2010, 02:44 PM
  5. Determining Aircraft arrival times
    By gregor49 in forum Excel General
    Replies: 1
    Last Post: 07-27-2006, 01:30 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1