I Most effective of 1000 groups given mean median mode and N

[reddvoid]

Hi,
For a SoC project I am working on I need to select one cell which is most critical.
example, If a bus is going through 1000 stops 1000 times I have mean median mode of delay contribution of that stop compared to the total delay to reach from start to stop point and N (number of times bus has gone through that stop).

How do I get the most critical bus stop of all the stops ?

Thanks&Regards.

Part of data I have -
cell Mean Median Mode Freq
------------------------------------------------------------
L09LP040L_USBUFX20 1.8 1.9 1.8 19736
L09LP040L_USBUFX08 0.9 0.8 0.7 9461
L09LP040L_USBUFAX16 1.6 1.6 1.6 9439
L09LP040L_USAN2X16 2.0 2.1 2.1 6987
L09LP040L_USAN2X04 2.8 2.8 2.7 5993
L09LP040L_USBUFX14 1.4 1.3 1.3 5406
L09LP030L_USBUFX20 1.5 1.5 1.3 5388
L09LP040L_USND2YX16 1.2 1.2 1.2 4931
L09LP040L_USND2X12 0.8 0.8 0.8 4553
L09LP040L_USIVX18 0.9 1.0 1.0 3908
L09LP040L_USIVX20 1.2 1.3 1.4 3783
L09LP040L_USBUFX16 1.3 1.3 1.3 3594
L09LP040L_USAN2FX12 1.5 1.5 1.1 3489
L09LP030L_USIVX20 0.8 0.8 0.6 3320
L09LP040L_USOR2IX16 1.8 1.8 1.5 3006

 

[mfb]

What do you mean by "the most critical bus stop"?

What does the "1000 times" mean if your frequency values are all above 1000?

 

[Stephen Tashi]

And what do you mean by:

compared to the total delay

Is a datum like 1.8 in units of time (e.g. 1.8 minutes) or is it in some "comparative" unit like "1.8 times the average time per stop" ?
?

 

[reddvoid]

In the example I gave, by most critical I meant the one which is contributing most to the total delay in general, Frequency is number of times each cell(or stop) is appearing and I gave 1000 times just for example , In the data I have, as you can see the frequencies are different for different cells...
and 1.8 is the percent of total delay contributed by that particular cell (or stop)..
Its like there are some x paths and in x paths there are different cells contributing to the delay of the path
so In all the paths the percent of delay contributed by each cell is calculated. since each cell is occurring multiple times in multiple paths and contributing different delay at different instances, I have taken mean of all the percentage delay contributions for each cell and that is in second column , same way I 've taken median and mode

 

[mfb]

In the example I gave, by most critical I meant the one which is contributing most to the total delay in general

How is "total delay in general" defined? Just the mean multiplied by the frequency?

Why do you have percentages instead of absolute numbers?

 

[reddvoid]

@mfb
Hi,

Like this there are thousands of paths with different cells .

 

[Stephen Tashi]

Like this there are thousands of paths with different cells .

The answer is going to depend on how often buses take each path, isn't it?

Are you dealing with a problem that actually involves buses in real life? They have scheduled routes don't they? There are lots of possible routes in a city that no bus is ever scheduled to take.