AI Analysis: Railway industry property accounts summary of regional companies

Executive Summary

Statistics Canada's Table 23100050 tracks railway industry property accounts for regional Canadian companies across 39 years (1986–2024), revealing a 16% growth in total property value from $11.4 billion to $13.2 billion, peaking at $15.9 billion in 2004. The dataset is heavily right-skewed, with a mean of $471,834K versus a median of $86,102K, reflecting the dominance of a few high-value asset categories — particularly 'Ways and Structures and Equipment' — over smaller accounts. Strong correlations between key categories (e.g., Rolling Stock and Total Equipment at r=0.993) suggest that capital investment cycles affect all asset types simultaneously.

Key Findings

• Total railway property value grew 16% over the study period, rising from $11.4 billion in 1986 to $13.2 billion in 2024, with a notable peak of $15.9 billion in 2004 followed by a decline and partial recovery.
• 'Ways and Structures and Equipment' is the dominant property account category by average value across all 39 years, consistently outpacing all other asset types.
• The dataset is strongly right-skewed: the mean value of $471,834K is nearly 5.5 times the median of $86,102K, with a standard deviation of $740,778K and values ranging from $0 to $4,314,341K.
• Rolling Stock (revenue service) and Total Equipment are almost perfectly correlated (r=0.993), while Total Ways and Structures and Track and Roadway show a near-equally strong relationship (r=0.983), indicating tightly linked investment cycles.
• Z-score outlier analysis (threshold: |z| > 2.5) identified significant anomalies across multiple property account categories and years, with some accounts recording zero values in isolated years that may indicate reporting gaps or asset disposals.
• The dataset covers 14 distinct property account categories across 980 records, with two value snapshots per year (beginning and end of year balances), enabling precise year-over-year change analysis for each asset type.
• Buildings and Related Machinery showed strong correlations with both Rolling Stock (r=0.870) and Total Equipment (r=0.857), suggesting broad capital investment cycles simultaneously influence multiple asset categories across regional railway companies.