Data-Driven Perspectives on Federal Budgetary Dynamics for Identifying Anomalies and Patterns in Resource Allocation and Obligation Trends
Rafiqus Salehin Khan
Data & Assessment Associate at Success Academy Charter Schools, NYC
https://orcid.org/0009-0002-5634-4681
Md Riad Mahamud Sirazy
Technology Integration Associate (Information Technology), Shine Electronics Co. NYC
https://orcid.org/0009-0009-4838-1635
Rahul Das
Device Quality Engineer, Shine Electronics Co. NYC
https://orcid.org/0009-0008-0365-4399
Sharifur Rahman
MSc in Business Analytics, University of Central Oklahoma, USA
https://orcid.org/0009-0009-5465-7159
Keywords: anomalies, budgeting practices, clustering models, efficiency, resource allocation, spending patterns, outlier detection
Abstract
Federal agencies tasked with significant program mandates often exhibit uneven spending patterns that can obscure broader fiscal objectives. This study investigated how major sub-components allocate and obligate resources over multiple years, seeking to identify common behaviors, anomalies, and possible influences on spending decisions. Objectives included examining efficiency, detecting outliers, and grouping sub-components according to their historical trends to guide refined budgeting practices. Methods encompassed K-means and hierarchical clustering, correlation analysis to assess alignment between resources and obligations, outlier detection through z-score and interquartile range, and linear regression to quantify directionality in spending patterns. Results highlighted several trajectories, with the “Centers for Medicare and Medicaid Services” emerging as a clear outlier due to rapid escalation in obligations that exceeded standard expectations. The “Office of Federal Student Aid” showed a contrasting scenario, underspending its allocated resources and displaying negative z-scores by 2023. Meanwhile, the “Food and Nutrition Service” maintained a balanced ratio of obligations to allocations, pointing to stable management processes. Clustering models grouped agencies into stable, quickly increasing, and fluctuating spending categories, revealing operational parallels among sub-components that share cluster assignments. Correlation tests affirmed a strong linkage between resource distribution and spending outcomes in most cases, notwithstanding a few anomalies. Recommendations highlight the importance of embedding advanced data analytics in budgetary supervision, reinforcing real-time monitoring to enable early detection of deviations and fostering inter-agency collaboration in the dissemination of best practices. Forward-looking strategies focused on adaptive budget allocations and methodological refinements promise stronger alignment between designated resources and evolving policy imperatives.