Mapping the Global Academic Funnel: A Data-Driven Analysis of Student Progression, Attrition, and Associated Costs

The pathway from secondary education to a career in academic research, often conceptualized as a funnel, is characterized by intense competition and sequential attrition. This study presents a consolidated, data-driven model of this global academic funnel. Using a deterministic cohort-based approach, we track the progression of 1,000 students from senior secondary education to the ultimate stage of an academic scientist. Our analysis reveals extreme attrition, with only 0.7% of the initial cohort (7 individuals) surviving the entire pipeline. The most significant drop-offs occur at the Bachelor's to Master's (50% attrition) and Master's to PhD (75% attrition) transitions. We further quantify the fate of filtered-out students, showing a predominant shift into the workforce, with entrepreneurship emerging as a notable pathway for 15-20% of Master's and PhD dropouts. Concurrent analysis of average annual education costs shows a steep increase up to the Master's level (USD 13,500-85,000), decreasing at doctoral stages due to funding structures. This model highlights systemic inefficiencies and profound inequality in access to advanced education, providing an empirical basis for policy interventions aimed at improving equity and human capital distribution.