Outlier months in produced quantity
For the latest 12 monthly totals of produced quantity, 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
-
FactProductionTransactions, DimDate · columns
- Topics
- Forecasting & Planning