Real-Time Data Validation and Anomaly Detection Framework

Create an Excel-based data validation system that automatically detects statistical anomalies using z-score and interquartile range methods. The framework should provide real-time flagging of outliers, generate detailed anomaly reports, and include configurable threshold settings. Implement advanced error handling, automatic data cleaning recommendations, and a visual dashboard showing data quality metrics and detected irregularities.