Excel Removing Outliers from Pivot Table Data

Removing Outliers from pivot table data can be a bit tricky, but I've made a step by step video of how to identify and filter outliers from a pivot tables source data. I'll go through and example looking at production data where I would like to summarize by average values, but because of outliers, the data is skewed. To eliminate this problem, I show you how to find each quartile (Q1, Q2 - Median, and Q3), calculate the IQR, and then determine outliers. Welcome to The Engineer Toolbox Channel, where I give you the tools you need to solve real world engineering problems! - - - - - - - - - - - - - - - - - - - - Other great content! Removing Outliers from Excel Pivot Table (Pt 2): https://www.youtube.com/watch?v=JUgEwyWSn4k What are outliers: https://www.youtube.com/watch?v=HdpKGl_ueic Excel For Engineers: Other https://www.youtube.com/watch?v=-zvxn4bQr-E&list=PLAVcy54svukf-joaAQHcy_GiSrtqy0p00 Excel Tips and Tools Every Engineer Should Know: https://www.youtube.com/watch?v=V-dG0sIPjYc&list=PLAVcy54svukcjnomjQSdKGoVRXwPepCGl - - - - - - - - - - - - - - - - - - - - Follow and interact! Twitter: https://twitter.com/TheEngToolbox Facebook: https://www.facebook.com/TheEngineeringToolbox/ - - - - - - - - - - - - - - - - - - - - #EngineeringToolbox #ExcelForEngineers #Statistics #EngineeringTutorials #EngineeringTips #ProblemSolvingTools #Engineering #Excel