Higher Education Distribution & Coverage Analysis

By abhishek.verma75000 · May 3, 2026

This report analyzes 37,700 colleges to assess institutional distribution, university affiliations, and DCF applicability. Type 1 institutions dominate…

The analysis identified the top 10 universities with the most affiliated colleges. A bar chart has been generated showing each university ranked by their college count, along with detailed data tables for further exploration.

The bar chart and data tables show which states have the highest concentration of colleges. A visualization has been generated ranking the top 10 states by college count, giving you a clear picture of where colleges are most densely distributed across the country.

The analysis shows that overall, 98.14% of colleges have DCF applicable. A bar chart has been generated showing the percentage of DCF-applicable colleges broken down by college type, with each bar labeled with its exact percentage. The visualization uses a blue color scale to highlight differences across the college types.

Across all 37,700 colleges analyzed, the distribution is heavily skewed toward Type 1 institutions. A bar chart and pie chart have been generated to visually illustrate this breakdown. Type 1 accounts for nearly 9 out of every 10 colleges, while the remaining three types make up just over 10% combined.

The analysis covers 630 districts in total. District 572 has the highest college density with 903 colleges, making it a major education hub. On the other end, District 285 has the lowest density with just 1 college. On average, districts have about 59.8 colleges, though the median is 34.5, suggesting a skewed distribution where a few districts have significantly more colleges than most. Two bar charts have been generated showing the top 10 and bottom 10 districts by college count.

The analysis examined how college types are distributed across the 10 states with the most colleges (states 27, 9, 29, 23, 8, 28, 33, 36, 24, and 21). Two visualizations were generated: a stacked bar chart showing raw counts and a 100% stacked bar chart showing percentage share, making it easy to compare both absolute numbers and relative composition across states.

The analysis successfully ranked the top 15 states by their DCF applicability rate — the percentage of colleges in each state that are DCF-applicable. A horizontal bar chart was generated showing these states sorted from highest to lowest DCF applicability rate, making it easy to visually compare which states have the greatest concentration of DCF-applicable institutions.

The analysis identified the top 20 universities with the highest number of affiliated colleges. A horizontal bar chart has been generated showing each university (by ID) ranked by college count, and you can hover over each bar to see additional details including the number of distinct districts and states covered, the most common college type, and the DCF applicability rate.

The analysis grouped colleges by type id and produced a summary table along with a stacked bar chart showing type distribution across the top 10 states. There are 4 distinct college types in the dataset. Type 1 dominates with 33,925 colleges spread across 35 states and 625 districts, and nearly all (99.99%) have DCF applicable. Types 2, 3, and 4 are much smaller in count but still span a wide geographic range. The stacked bar chart visually shows how these types are distributed across the 10 most represented states.

The analysis examined how colleges are distributed across 630 districts. A histogram was generated showing the distribution of college counts per district, and key statistics were computed. The distribution is heavily right-skewed, with a mean of 59.84 colleges per district but a median of only 34.5, indicating most districts have fewer colleges while a few have very large numbers. Using the IQR method, 44 districts were identified as high outliers (with more than 169.88 colleges), while no districts fell below the lower bound.