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

• I
• reddvoid
In summary, the person is working on a SoC project and needs to select the most critical cell out of a list of cells. They have data on the mean, median, mode, and frequency of stops for a bus route. The person is trying to determine the most critical bus stop based on the frequency and delay contribution of each stop. They mention that the data is in percentages and that there are thousands of paths with different cells. The definition of "total delay in general" is not clear and the answer may depend on how often buses take each path. The person is dealing with a problem that involves buses in real life and mentions that there are scheduled routes and many possible routes that buses do not take.

#### 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

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

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

And what do you mean by:
reddvoid said:
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" ?
?

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

reddvoid said:
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?

@mfb
Hi,

Like this there are thousands of paths with different cells .

#### Attachments

• IMG_20160520_145853.jpg
23.8 KB · Views: 464
reddvoid said:
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.

## 1. What is the mean of the 1000 groups?

The mean is the average of all the values in the 1000 groups. It is calculated by adding up all the values and then dividing by the total number of values.

## 2. What is the median of the 1000 groups?

The median is the middle value when all the values in the 1000 groups are arranged in ascending or descending order. If there is an even number of values, the median is the average of the two middle values.

## 3. What is the mode of the 1000 groups?

The mode is the value that appears most frequently in the 1000 groups. It is possible to have more than one mode if there are multiple values that appear the same number of times.

## 4. How is the most effective group determined?

The most effective group is determined by comparing the mean, median, and mode of all 1000 groups. The group with the highest values for all three measures is considered the most effective.

## 5. What does the value of N represent?

The value of N represents the total number of values in each of the 1000 groups. It is used to calculate the mean, median, and mode.