How to Remove Outliers Using Excel: Boxplot Method in Excel (Interquartile Range/IQR Method)

[@ramneek4344]

will the outliers cause a flawed normal distribution curve?

[@ShivanandThorat]

Yes. And outliers can also deviate mean and standard deviation resulting in an erroneous inference.

[@luisfevel]

Thank you!!!

[@riyachhabra4915]

Thanku so much sir

[@ShivanandThorat]

Thanks for watching. Consider subscribing the channel if you find content helpful.

[@katy8791]

Nice video👍

[@ShivanandThorat]

Thanks Katy

[@SatishJadhav-rr1oq]

Thank u sir nice video

[@ShivanandThorat]

Sir kay aree 😆

[@NobixLee]

Not useful when you have thousands of outliers, excel needs to create a feature where you can just click to remove outliers.

[@ShivanandThorat]

It is a researcher's decision whether to continue with some outliers or not. So auto outliers removal is not a good choice. Researcher should remove outliers one or maximum 2 at a time and re-run analysis. Removing multiple outliers at the same time is not a good idea. Hope this helps.

[@anaghakulkarni2124]

👍👍

[@kaushalgorle1203]

👍👍👍