Statistics for Beginners in Excel – Identifying Outliers and Missing Data using Real Statistics

(Basic Statistics for Citizen Data Scientist) Identifying Outliers and Missing Data The Real Statistics Resource Pack provides an option for identifying potential outliers in a sample. Assuming the sample is normally distributed (based on the Central Limit Theorem), we know that NORM.S.DIST(-2.5,TRUE) = 0.621% of the data should have a z-score less than -2.5. Similarly … Continue reading Statistics for Beginners in Excel – Identifying Outliers and Missing Data using Real Statistics