Analysis of Cell Performance Metrics from RALI TT Dataset

Nov 10, 2024, 8:15 AM

RALI TT.xlsx

Missing file

look to cell name column and do a deep analysis for each item

The analysis of the Cell Name column shows the following counts for each cell:
  • CAMP06L-1: 453 occurrences
  • CAMP06L-2: 453 occurrences
  • CAMP06L-3: 453 occurrences
  • MIS-ECVL-1: 275 occurrences
  • MIS-ECVL-3: 275 occurrences
  • MIS-ECVL-2: 275 occurrences
  • CAMP05L-1: 252 occurrences
  • CAMP05L-4: 252 occurrences
This indicates that the data is distributed across several cell names, with the CAMP06L series having the highest number of occurrences. If you need further analysis on specific metrics related to these cell names, please let me know!

do data analysis for each one of them :

The data analysis for each Cell Name includes the following metrics:

RRC Establishment Success Rate (%)

  • CAMP05L-1: Mean = 98.31%, Std = 7.02%
  • CAMP05L-4: Mean = 97.37%, Std = 9.48%
  • CAMP06L-1: Mean = 94.99%, Std = 8.40%
  • CAMP06L-2: Mean = 88.72%, Std = 15.52%
  • CAMP06L-3: Mean = 93.93%, Std = 12.51%
  • MIS-ECVL-1: Mean = 89.87%, Std = 12.99%
  • MIS-ECVL-2: Mean = 82.03%, Std = 18.07%
  • MIS-ECVL-3: Mean = 100.00%, Std = 0.00%

E-RAB Setup Success Rate (%)

  • CAMP05L-1: Mean = 99.03%, Std = 2.32%
  • CAMP05L-4: Mean = 98.93%, Std = 2.62%
  • CAMP06L-1: Mean = 97.89%, Std = 4.80%
  • CAMP06L-2: Mean = 96.42%, Std = 6.15%
  • CAMP06L-3: Mean = 98.56%, Std = 3.89%
  • MIS-ECVL-1: Mean = 98.88%, Std = 3.15%
  • MIS-ECVL-2: Mean = 99.20%, Std = 2.56%
  • MIS-ECVL-3: Mean = 100.00%, Std = 0.00%

UE Context Establishment Success Rate (%)

  • CAMP05L-1: Mean = 100.00%, Std = 0.00%
  • CAMP05L-4: Mean = 100.00%, Std = 0.00%
  • CAMP06L-1: Mean = 99.99%, Std = 0.01%
  • CAMP06L-2: Mean = 99.99%, Std = 0.01%
  • CAMP06L-3: Mean = 100.00%, Std = 0.00%
  • MIS-ECVL-1: Mean = 100.00%, Std = 0.00%
  • MIS-ECVL-2: Mean = 100.00%, Std = 0.00%
  • MIS-ECVL-3: Mean = 100.00%, Std = 0.00%

Cell Uplink BLER (%)

  • CAMP05L-1: Mean = 0.03%, Std = 0.01%
  • CAMP05L-4: Mean = 0.03%, Std = 0.01%
  • CAMP06L-1: Mean = 0.05%, Std = 0.02%
  • CAMP06L-2: Mean = 0.06%, Std = 0.02%
  • CAMP06L-3: Mean = 0.04%, Std = 0.01%
  • MIS-ECVL-1: Mean = 0.04%, Std = 0.01%
  • MIS-ECVL-2: Mean = 0.03%, Std = 0.01%
  • MIS-ECVL-3: Mean = 0.00%, Std = 0.00%

Cell Downlink BLER (%)

  • CAMP05L-1: Mean = 0.11%, Std = 0.01%
  • CAMP05L-4: Mean = 0.11%, Std = 0.01%
  • CAMP06L-1: Mean = 0.11%, Std = 0.03%
  • CAMP06L-2: Mean = 0.11%, Std = 0.02%
  • CAMP06L-3: Mean = 0.12%, Std = 0.02%
  • MIS-ECVL-1: Mean = 0.11%, Std = 0.01%
  • MIS-ECVL-2: Mean = 0.11%, Std = 0.01%
  • MIS-ECVL-3: Mean = 0.00%, Std = 0.00%

Number of Ping-Pong Handover

  • CAMP05L-1: Mean = 0.14, Std = 0.42
  • CAMP05L-4: Mean = 0.20, Std = 0.51
  • CAMP06L-1: Mean = 8.93, Std = 6.59
  • CAMP06L-2: Mean = 20.96, Std = 16.45
  • CAMP06L-3: Mean = 10.97, Std = 9.20
  • MIS-ECVL-1: Mean = 0.86, Std = 1.72
  • MIS-ECVL-2: Mean = 2.45, Std = 6.81
  • MIS-ECVL-3: Mean = 0.00, Std = NaN
This analysis provides insights into the performance and reliability of each cell. If you have any specific questions or need further analysis, feel free to ask!

do it for all KPIs

The detailed analysis for each Cell Name across all KPIs includes the following statistics:

RRC Establishment Success Rate (%)

  • CAMP05L-1: Mean = 98.31%, Std = 7.02%, Min = 57.49%, Max = 100%
  • CAMP05L-4: Mean = 97.37%, Std = 9.48%, Min = 47.22%, Max = 100%
  • CAMP06L-1: Mean = 94.99%, Std = 8.40%, Min = 68.09%, Max = 100%
  • CAMP06L-2: Mean = 88.72%, Std = 15.52%, Min = 49.93%, Max = 100%
  • CAMP06L-3: Mean = 93.93%, Std = 12.51%, Min = 51.82%, Max = 100%
  • MIS-ECVL-1: Mean = 89.87%, Std = 12.99%, Min = 59.56%, Max = 100%
  • MIS-ECVL-2: Mean = 82.03%, Std = 18.07%, Min = 37.04%, Max = 100%
  • MIS-ECVL-3: Mean = 100.00%, Std = 0.00%, Min = 100%, Max = 100%

E-RAB Setup Success Rate (%)

  • CAMP05L-1: Mean = 99.03%, Std = 2.32%, Min = 91.67%, Max = 100%
  • CAMP05L-4: Mean = 98.93%, Std = 2.62%, Min = 88.89%, Max = 100%
  • CAMP06L-1: Mean = 97.89%, Std = 4.80%, Min = 80.00%, Max = 100%
  • CAMP06L-2: Mean = 96.42%, Std = 6.15%, Min = 66.67%, Max = 100%
  • CAMP06L-3: Mean = 98.56%, Std = 3.89%, Min = 80.00%, Max = 100%
  • MIS-ECVL-1: Mean = 98.88%, Std = 3.15%, Min = 80.00%, Max = 100%
  • MIS-ECVL-2: Mean = 99.20%, Std = 2.56%, Min = 80.00%, Max = 100%
  • MIS-ECVL-3: Mean = 100.00%, Std = 0.00%, Min = 100%, Max = 100%

UE Context Establishment Success Rate (%)

  • CAMP05L-1: Mean = 100.00%, Std = 0.00%, Min = 100%, Max = 100%
  • CAMP05L-4: Mean = 100.00%, Std = 0.00%, Min = 100%, Max = 100%
  • CAMP06L-1: Mean = 99.99%, Std = 0.01%, Min = 99.99%, Max = 100%
  • CAMP06L-2: Mean = 99.99%, Std = 0.01%, Min = 99.99%, Max = 100%
  • CAMP06L-3: Mean = 100.00%, Std = 0.00%, Min = 100%, Max = 100%
  • MIS-ECVL-1: Mean = 100.00%, Std = 0.00%, Min = 100%, Max = 100%
  • MIS-ECVL-2: Mean = 100.00%, Std = 0.00%, Min = 100%, Max = 100%
  • MIS-ECVL-3: Mean = 100.00%, Std = 0.00%, Min = 100%, Max = 100%

Cell Uplink BLER (%)

  • CAMP05L-1: Mean = 0.03%, Std = 0.01%, Min = 0.01%, Max = 0.07%
  • CAMP05L-4: Mean = 0.03%, Std = 0.01%, Min = 0.01%, Max = 0.07%
  • CAMP06L-1: Mean = 0.05%, Std = 0.02%, Min = 0.02%, Max = 0.11%
  • CAMP06L-2: Mean = 0.06%, Std = 0.02%, Min = 0.02%, Max = 0.12%
  • CAMP06L-3: Mean = 0.04%, Std = 0.01%, Min = 0.02%, Max = 0.08%
  • MIS-ECVL-1: Mean = 0.04%, Std = 0.01%, Min = 0.02%, Max = 0.06%
  • MIS-ECVL-2: Mean = 0.03%, Std = 0.01%, Min = 0.01%, Max = 0.06%
  • MIS-ECVL-3: Mean = 0.00%, Std = 0.00%, Min = 0.00%, Max = 0.00%

Cell Downlink BLER (%)

  • CAMP05L-1: Mean = 0.11%, Std = 0.01%, Min = 0.08%, Max = 0.14%
  • CAMP05L-4: Mean = 0.11%, Std = 0.01%, Min = 0.08%, Max = 0.14%
  • CAMP06L-1: Mean = 0.11%, Std = 0.03%, Min = 0.05%, Max = 0.17%
  • CAMP06L-2: Mean = 0.11%, Std = 0.02%, Min = 0.06%, Max = 0.17%
  • CAMP06L-3: Mean = 0.12%, Std = 0.02%, Min = 0.08%, Max = 0.16%
  • MIS-ECVL-1: Mean = 0.11%, Std = 0.01%, Min = 0.09%, Max = 0.16%
  • MIS-ECVL-2: Mean = 0.11%, Std = 0.01%, Min = 0.09%, Max = 0.14%
  • MIS-ECVL-3: Mean = 0.00%, Std = 0.00%, Min = 0.00%, Max = 0.00%

Number of Ping-Pong Handover

  • CAMP05L-1: Mean = 0.14, Std = 0.42, Min = 0, Max = 3
  • CAMP05L-4: Mean = 0.20, Std = 0.51, Min = 0, Max = 3
  • CAMP06L-1: Mean = 8.93, Std = 6.59, Min = 0, Max = 31
  • CAMP06L-2: Mean = 20.96, Std = 16.45, Min = 0, Max = 73
  • CAMP06L-3: Mean = 10.97, Std = 9.20, Min = 0, Max = 42
  • MIS-ECVL-1: Mean = 0.86, Std = 1.72, Min = 0, Max = 14
  • MIS-ECVL-2: Mean = 2.45, Std = 6.81, Min = 0, Max = 92
  • MIS-ECVL-3: Mean = 0.00, Std = NaN, Min = 0, Max = 0
This comprehensive analysis provides insights into the performance and reliability of each cell across all key performance indicators (KPIs). If you have any specific questions or need further analysis, feel free to ask!

Can you visualize the KPI trends over time?

do it for any drop rate KPI

Can you analyze the correlation between different KPIs?

The correlation analysis between different KPIs reveals the following insights:

Positive Correlations

  • E-RAB Setup Success Rate (%) and UE Context Establishment Success Rate (%) have a very high positive correlation (0.9997), indicating that as one increases, the other tends to increase as well.

Negative Correlations

  • RRC Establishment Success Rate (%) has a negative correlation with both Cell Uplink BLER (%) (-0.1226) and Cell Downlink BLER (%) (-0.2418), suggesting that higher BLER rates are associated with lower RRC success rates.
  • Number of Ping-Pong Handover shows a negative correlation with RRC Establishment Success Rate (%) (-0.1511), indicating that more frequent handovers might be associated with lower RRC success rates.

Other Observations

  • Cell Uplink BLER (%) and Cell Downlink BLER (%) have a moderate positive correlation (0.6636), suggesting that issues affecting uplink quality might also impact downlink quality.
These correlations can help identify potential areas for improvement and further investigation. If you have any specific questions or need further analysis, feel free to ask!

Can you visualize the correlation matrix?

How do the KPIs vary by time of day?

Get started with Vizly