University Staff Records Analysis: Distribution, Coverage, and Structural Data Quality

By abhishek.verma75000 · May 3, 2026

Analysis of 3,556 teaching staff records across 610 universities shows an average of 5.83 records per university with generally balanced distribution.…

On average, each university has approximately 5.83 staff records. This is calculated across 610 universities with a total of 3,556 staff records in the dataset.

The analysis identified the top 10 universities with the highest number of sanctioned teaching staff strength records. A bar chart has been generated showing each university's record count, and a data table is also available for detailed reference.

Every single university in the dataset has multiple teaching staff sanctioned strength entries. Out of 610 unique universities, all 610 (100%) have more than one entry recorded.

The dataset covers university IDs from 1 to 664, but 54 IDs are missing, indicating coverage gaps. The dataset achieves 91.87% coverage with 610 out of 664 possible IDs present. The first 30 missing IDs include: 8, 22, 26, 29, 61, 79, 113, 192, 198, 200, 279, 336, 338, 342, 343, 344, 365, 373, 402, 403, 404, 411, 416, 417, 423, 424, 425, 524, 529, and 531, plus 24 additional missing IDs beyond those.

The range of staff IDs varies significantly across top universities. Two bar charts and supporting data tables were generated to illustrate this. On average, the top 15 universities (ranked by staff record count) have a staff ID range of about 7,720. However, this varies enormously — University 196 has the largest range of 115,638 (IDs from 93,114 to 208,752), while University 78 has the smallest range of just 10 (IDs from 184,865 to 184,875). Since staff IDs are largely assigned sequentially, a wider range generally indicates more staff records spread over a longer period of data entry.

Teaching staff sanctioned records are spread across 610 universities, totaling 3,556 records. The distribution is relatively even, with an average of 5.83 records per university and a median of 5. Two visualizations were generated: a bar chart showing the top 10 universities by record count, and a histogram showing the overall distribution of records per university.

The analysis examined teaching staff record counts across 610 universities and identified 9 outliers using the IQR method. The interquartile range (IQR) was 2.8, with Q1 at 4.2 records and Q3 at 7.0 records. Universities with record counts outside the range of [0.1, 11.1] were flagged as outliers — meaning any university with more than 11 records is statistically unusual. A box plot has been generated showing the full distribution of records per university, with outlier points clearly highlighted.

The analysis successfully ranked all universities by their total number of teaching staff sanctioned strength records and segmented them into four quartile groups. A bar chart has been generated comparing the size of each quartile group (Top 25%, Upper-Mid 25%, Lower-Mid 25%, and Bottom 25%), along with supporting data tables showing the count and percentage of universities in each segment.

The dataset contains 3,556 total records spanning 610 unique universities, giving an average of 5.83 records per university. The teaching staff sanctioned strength id field ranges widely from 282 to 292,781 — a spread of 292,499. The distribution is fairly spread out: Q1 is ~42,636, the median is ~87,759, and Q3 is ~133,392, suggesting a right-skewed distribution with some high-value outliers. A summary table and a box plot have been generated to visualize these findings clearly.

The analysis of teaching staff sanctioned strength id values across 3,556 records reveals a highly sparse and non-continuous ID sequence. The IDs range from 282 to 292,781, but only 1.22% of that range is actually used. A histogram and box plot were generated to visualize the spread, with mean (red dashed line) and median (green dashed line) markers overlaid on the histogram.