+ Reply to Thread
Results 1 to 5 of 5

Thread: very simple logic question

  1. #1
    Fortran must die
    Points: 52,364, Level: 100
    Level completed: 0%, Points required for next Level: 0
    noetsi's Avatar
    Posts
    6,479
    Thanks
    681
    Thanked 912 Times in 871 Posts

    very simple logic question




    This is probably the simplest question ever asked here.....

    I have been asked for the average time customers spent in a given service.

    Some customers are in the service multiple times. They way I have calculated the response to the question, is the total time in services divided by the number of times the service is taken. This is really the average time the service takes.

    Should I instead sum up the time each customer has gone through services (this will add up the multiple service times for those customers who have multiple services and connect it to a specific customer) and divide the sum of this by the number of customers?

    Been working to much recently....this is probably too simple a question to even think about.
    "Very few theories have been abandoned because they were found to be invalid on the basis of empirical evidence...." Spanos, 1995

  2. #2
    Omega Contributor
    Points: 35,840, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    6,734
    Thanks
    383
    Thanked 1,135 Times in 1,096 Posts

    Re: very simple logic question

    Are subsequent times indepenent? Or does the length of time change based on the number of times? Do people with multiple times differ from those with fewer?

    If I go to H&R block two years in a row for my taxes, it is likely the second time is faster since I am familiar with the process and they already have data loaded into the system
    Stop cowardice, ban guns!

  3. The Following User Says Thank You to hlsmith For This Useful Post:

    noetsi (02-17-2017)

  4. #3
    Super Moderator
    Points: 13,151, Level: 74
    Level completed: 76%, Points required for next Level: 99
    Dragan's Avatar
    Location
    Illinois, US
    Posts
    2,014
    Thanks
    0
    Thanked 223 Times in 192 Posts

    Re: very simple logic question

    Quote Originally Posted by noetsi View Post
    This is probably the simplest question ever asked here.....

    I have been asked for the average time customers spent in a given service.

    Some customers are in the service multiple times. They way I have calculated the response to the question, is the total time in services divided by the number of times the service is taken. This is really the average time the service takes.

    Should I instead sum up the time each customer has gone through services (this will add up the multiple service times for those customers who have multiple services and connect it to a specific customer) and divide the sum of this by the number of customers?

    Been working to much recently....this is probably too simple a question to even think about.

    I suspect that you should compute a weighted average; which is based on what you intimated in Part 3 of your first post.

  5. #4
    Omega Contributor
    Points: 35,840, Level: 100
    Level completed: 0%, Points required for next Level: 0
    hlsmith's Avatar
    Location
    Not Ames, IA
    Posts
    6,734
    Thanks
    383
    Thanked 1,135 Times in 1,096 Posts

    Re: very simple logic question

    Is time value normally distributed?


    May think about something like this if time variabe may be dependent on person:


    Code: 
    proc mixed data=data_set method = reml covtest;
     class ID;
     model time = / solution;
     random intercept / subject=ID solution;
     run;
    Stop cowardice, ban guns!

  6. The Following User Says Thank You to hlsmith For This Useful Post:

    noetsi (02-17-2017)

  7. #5
    Fortran must die
    Points: 52,364, Level: 100
    Level completed: 0%, Points required for next Level: 0
    noetsi's Avatar
    Posts
    6,479
    Thanks
    681
    Thanked 912 Times in 871 Posts

    Re: very simple logic question


    I am not sure whether the times are independent or not in honesty. They go to different vendors and different training so effectively one training probably has no impact on the time of the next training.

    I wanted to thank hlsmith and dragan for their comments. As is often the case the decision was administrative rather than logic based. They asked us for the simplest answer, we gave them average time in service which was quickest to compute. But I learned from this thread which will help in the future.
    "Very few theories have been abandoned because they were found to be invalid on the basis of empirical evidence...." Spanos, 1995

+ 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