Outlier months in contribution before overhead
For the latest 12 monthly totals of contribution before overhead, identify unusual months using modified z-scores: 0.6745 times deviation from the median divided by MAD, with absolute scores above 3.5 flagged. If MAD is zero, report no flags. Compare the original mean with the mean after clipping totals to median plus/minus 3 MAD, and discuss the planning sensitivity without treating flags as errors.
- Expected
- 12 months: value, median, MAD, score, flag, clipped value; both means and change · Trend and exception table
- Tables
-
FactHospitalEncounters, FactBilling, DimDate · columns
- Topics
- Forecasting & Planning