32 Data Discrepancy Investigation
32.1 Executive Summary
We identified a mismatch between the log-derived data (used in early forecasts) and the official monthly statistics (CSV). This investigation quantifies that gap.
- Reference (CSV): The “Ground Truth” from administrative records.
- Log Data: Derived from machine logs (Lab LIS, Scanners, PACS).
32.2 1. Visualizing the Drop-off
The chart below shows where the log data starts to diverge from the reference counts. A sharp divergence indicates where logs became incomplete or failed to capture the full workflow.
32.3 2. Completeness Ratio
This chart shows the percentage of “Truth” captured by the logs over time. 100% means the logs match the CSV perfectly.
32.4 3. Discrepancy Detail Table
The table below highlights the exact missing counts per month.
- Negatives in “Missing” columns would mean logs show more than the reference (unlikely).
- Positives indicate how many cases are missing from the logs.
| Month | Ref Cases | Lab Log Count | Scanner Log Count | Lab Completeness % | Scanner Completeness % |
|---|---|---|---|---|---|
| 2025-11 | NA | NA | 473 | NA | NA |
| 2025-10 | NA | 469 | NA | NA | NA |
| 2025-10 | NA | NA | 406 | NA | NA |
| 2025-09 | NA | 510 | NA | NA | NA |
| 2025-09 | NA | NA | 403 | NA | NA |
| 2025-08 | NA | 540 | NA | NA | NA |
| 2025-08 | NA | NA | 383 | NA | NA |
| 2025-07 | 5514 | 381 | NA | 6.9 | NA |
| 2025-07 | NA | NA | 551 | NA | NA |
| 2025-06 | 6298 | 546 | NA | 8.7 | NA |
| 2025-06 | NA | NA | 434 | NA | NA |
| 2025-05 | 5136 | 405 | NA | 7.9 | NA |
| 2025-05 | NA | NA | 20 | NA | NA |
| 2025-04 | 6593 | 3307 | NA | 50.2 | NA |
| 2025-03 | 6082 | 2762 | NA | 45.4 | NA |
| 2025-02 | 5494 | 2602 | NA | 47.4 | NA |
| 2025-01 | 5690 | 2506 | NA | 44.0 | NA |
| 2024-12 | 6129 | 3058 | NA | 49.9 | NA |
| 2024-11 | 6005 | 3421 | NA | 57.0 | NA |
| 2024-10 | 6113 | 3170 | NA | 51.9 | NA |
| 2024-09 | 5611 | 3138 | NA | 55.9 | NA |
| 2024-08 | 5567 | 2827 | NA | 50.8 | NA |
| 2024-07 | 5892 | 3141 | NA | 53.3 | NA |
| 2024-06 | 5750 | 2825 | NA | 49.1 | NA |
| 2024-05 | 4553 | 2544 | NA | 55.9 | NA |
| 2024-04 | 6543 | 3929 | NA | 60.0 | NA |
| 2024-03 | 5048 | 1944 | NA | 38.5 | NA |
| 2024-02 | 5833 | 3734 | NA | 64.0 | NA |
| 2024-01 | 5819 | NA | NA | NA | NA |
| 2023-12 | 6160 | NA | NA | NA | NA |
| 2023-11 | 6455 | NA | NA | NA | NA |
| 2023-10 | 5994 | NA | NA | NA | NA |
| 2023-09 | 6103 | NA | NA | NA | NA |
| 2023-08 | 5285 | NA | NA | NA | NA |
| 2023-07 | 5854 | NA | NA | NA | NA |
| 2023-06 | 5255 | NA | NA | NA | NA |
| 2023-05 | 4587 | NA | NA | NA | NA |
| 2023-04 | 5631 | NA | NA | NA | NA |
| 2023-03 | 5737 | NA | NA | NA | NA |
| 2023-02 | 6033 | NA | NA | NA | NA |
| 2023-01 | 4380 | NA | NA | NA | NA |
| 2022-12 | 5052 | NA | NA | NA | NA |
| 2022-11 | 5447 | NA | NA | NA | NA |
| 2022-10 | 5644 | NA | NA | NA | NA |
| 2022-09 | 4931 | NA | NA | NA | NA |
| 2022-08 | 4837 | NA | NA | NA | NA |
| 2022-07 | 6453 | NA | NA | NA | NA |
| 2022-06 | 3391 | NA | NA | NA | NA |
| 2022-05 | 5530 | NA | NA | NA | NA |
| 2022-04 | 4710 | NA | NA | NA | NA |
| 2022-03 | 5645 | NA | NA | NA | NA |
| 2022-02 | 5798 | NA | NA | NA | NA |
| 2022-01 | 4648 | NA | NA | NA | NA |
| 2021-12 | 4016 | NA | NA | NA | NA |
| 2021-11 | 5828 | NA | NA | NA | NA |
| 2021-10 | 5708 | NA | NA | NA | NA |
| 2021-09 | 5044 | NA | NA | NA | NA |
| 2021-08 | 4760 | NA | NA | NA | NA |
| 2021-07 | 4662 | NA | NA | NA | NA |
| 2021-06 | 3657 | NA | NA | NA | NA |
| 2021-05 | 5124 | NA | NA | NA | NA |
| 2021-04 | 3552 | NA | NA | NA | NA |
| 2021-03 | 3688 | NA | NA | NA | NA |
| 2021-02 | 4493 | NA | NA | NA | NA |
| 2021-01 | 3640 | NA | NA | NA | NA |