Skip to content

data_analysis_sample_results.md

Latest commit

 

History

History
214 lines (101 loc) · 2.92 KB

data_analysis_sample_results.md

File metadata and controls

214 lines (101 loc) · 2.92 KB

Sample Data Analysis Results:

This doc illustrates the sample data analysis results for each KQL query.

Speed

find_speed_z_score.kql

"Metric": Speed Z-Score Analysis (±2σ),

"AnalysisPeriod": 30 days ending 2025-11-16 21:15,

"TotalEvents": 86400,

"ZScoreUsed": 2,

"AvgSpeed": 65.09,

"StdDevSpeed": 18.435,

"CoefficientOfVariation_Percent": 28.32,

"LowerThreshold_ZScore2": 28.22,

"UpperThreshold_ZScore2": 101.96,

"ThresholdRange": 73.74,

"MinSpeed": 7.52,

"MaxSpeed": 129.86,

"MedianSpeed": 65.31,

"P5Speed": 34.23,

"P95Speed": 95.6,

"MinValue_ZScore": -3.12,

"MaxValue_ZScore": 3.51

Vibration

find_vibration_z_score.kql

"Metric": Vibration Z-Score Analysis (±2σ),

"AnalysisPeriod": 30 days ending 2025-11-16 21:14,

"TotalEvents": 86400,

"ZScoreUsed": 2,

"AvgVibration": 0.226,

"StdDevVibration": 0.083,

"CoefficientOfVariation_Percent": 36.78,

"VibrationRange": 0.52,

"PracticalLowerThreshold": 0.06,

"UpperThreshold_ZScore2": 0.391,

"ThresholdRange": 0.332,

"MinVibration": 0,

"MaxVibration": 0.52,

"MedianVibration": 0.22,

"P5Vibration": 0.11,

"P95Vibration": 0.37,

"MinValue_ZScore": -2.72,

"MaxValue_ZScore": 3.55

Temperature

find_temperature_z_score.kql

"Metric": Temperature Z-Score Analysis (±2σ),

"AnalysisPeriod": 30 days ending 2025-11-16 21:13,

"TotalEvents": 86400,

"ZScoreUsed": 2,

"AvgTemperature": 28.8,

"StdDevTemperature": 5.5,

"CoefficientOfVariation_Percent": 19.14,

"TemperatureRange": 29,

"LowerThreshold_ZScore2": 17.7,

"UpperThreshold_ZScore2": 39.8,

"ThresholdRange": 22,

"MinTemperature": 15.5,

"MaxTemperature": 44.5,

"MedianTemperature": 28.6,

"P5Temperature": 20.7,

"P95Temperature": 38.3,

"MinValue_ZScore": -2.41,

"MaxValue_ZScore": 2.86

Humidity

find_humidity_z_score.kql

"Metric": Humidity Z-Score Analysis (±2σ),

"AnalysisPeriod": 30 days ending 2025-11-16 21:10,

"TotalEvents": 86400,

"ZScoreUsed": 2,

"AvgHumidity": 49.98,

"StdDevHumidity": 11.781,

"LowerThreshold_ZScore2": 26.42,

"UpperThreshold_ZScore2": 73.54,

"ThresholdRange": 47.12,

"MinHumidity": 30,

"MaxHumidity": 70,

"MedianHumidity": 50,

"P5Humidity": 31.64,

"P95Humidity": 68.35,

"MinValue_ZScore": -1.7,

"MaxValue_ZScore": 1.7

Defect Probability

find_defect_probability_z_score.kql

"Metric": DefectProbability Z-Score Analysis (±2σ),

"AnalysisPeriod": 30 days ending 2025-11-16 21:05,

"TotalEvents": 86400,

"NonZeroEvents": 3172,

"NonZeroDefectRate_Percent": 3.67,

"ZScoreUsed": 2,

"AvgDefectProbability": 0.007882,

"StdDevDefectProbability": 0.047965,

"PracticalLowerThreshold": 0,

"UpperThreshold_ZScore2": 0.103811,

"ThresholdRange": 0.191859,

"MinDefectProbability": 0,

"MaxDefectProbability": 0.7,

"MedianDefectProbability": 0,

"P5DefectProbability": 0,

"P95DefectProbability": 0,

"P99DefectProbability": 0.31,

"P99_5DefectProbability": 0.377222,

"MinValue_ZScore": -0.16,

"MaxValue_ZScore": 14.43