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):
• Removing Outliers From Excel Pivot Ta...
What are outliers:
• What are outliers, How to Detect Them...
Excel For Engineers: Other
• Top 17 Excel Tips, Tricks, & Producti...
Excel Tips and Tools Every Engineer Should Know:
• Histograms (in Excel '16) Excel Tip...
Follow and interact!
Twitter: / theengtoolbox
Facebook: / theengineeringtoolbox
#EngineeringToolbox
#ExcelForEngineers
#Statistics
#EngineeringTutorials
#EngineeringTips
#ProblemSolvingTools
#Engineering
#Excel