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):
   • 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