AI Analysis: Central government operations: budgetary balance, non-budgetary transactions, and financial source/requirement

Executive Summary

Statistics Canada's Table 10100133 provides 16 years of monthly federal fiscal data (April 2009–December 2025) across 26 categories, revealing a heavily skewed distribution where the mean value of $3,671M dwarfs the median of just $22M, driven by a handful of extremely large transactions. The dataset captures Canada's central government operations through major fiscal shocks — including post-2008 recovery spending and COVID-19 stimulus — with values ranging from -$84,351M to +$135,825M CAD. Expenses, Program Expenses, and Revenues dominate as the largest fiscal categories, while 16 statistically significant outliers mark periods of genuinely exceptional fiscal activity.

Key Findings

• The dataset spans 201 monthly periods from April 2009 to December 2025, containing 5,226 rows and 26 distinct fiscal metrics all measured in millions of Canadian dollars.
• Values range enormously from -$84,351M to +$135,825M CAD, with a standard deviation of $12,316M, reflecting dramatic differences in scale across budgetary and non-budgetary transaction categories.
• The mean value of $3,671M is roughly 167 times larger than the median of $22M, confirming a heavily right-skewed distribution driven by a small number of very large fiscal flows.
• 41.6% of all recorded values are negative (deficits or outflows) while 58.4% are positive (surpluses or inflows), indicating the government more frequently recorded inflows but faced significant deficit periods.
• The top 3 categories by average value — Expenses, Program Expenses, and Revenues — represent the largest fiscal components and anchor the budgetary balance analysis.
• 16 outliers were detected across Revenues, Expenses, and Budgetary Balance using an IQR x2.5 threshold, likely corresponding to extraordinary fiscal events such as COVID-19 pandemic stimulus spending around 2020.
• Correlation analysis across all 26 variables shows that categories within the same fiscal grouping (e.g., budgetary revenues or non-budgetary transactions) cluster together with stronger mutual correlations, reflecting the structural relationships built into federal accounting.