View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meebers Meebers is offline
external usenet poster
 
Posts: 80
Default Finding center of a distribution

Trying to use the correct function(s) to find the center of a distribution
of numbers such that the sum of the numbers to the left of "center" equals
the sum of the numbers to the right. i.e. if the data points are, say 8 am,
9 am, 10 am.... thru 5 pm, and there are events thru out the day, I am
looking at what time has 50% of the events happen. Expected results
example= if the "center" happens at 3pm, means that 42 events happend before
3 pm and 42 events happened after 3 pm. TIA