Using Microsoft Excel to Determine Outliers

This video shows how to determine Outliers in a data set using Microsoft Excel.

[@cameronbenda2978]

Thank you for this clear explanation

[@farzanaizzati_]

Sir, thank you very much for your clear explanation it's helps a lot for my project :)

[@philipjano2799]

Thanks Sir for this clear explanation. Kind regards.

[@jskeshminder4627]

You are most welcome

[@julaimj]

TQ so much sir, very clear explanation. since class online thru i-class and google meets with my lecturer sometimes not very clear. #UiTMDihatiku

[@jskeshminder4627]

Tq Mj! I appreciate your comment. Happy to assists all my UiTM students. You have motivated me to create more and better videos in the future. Tq

[@wilfredocruz7440]

Great!!!!

[@jskeshminder4627]

Pleasure

[@binit554]

where is the excel file in the description

[@vijeshvk85]

"$" sign is not needed in the array?

[@98DYR]

Hi, thanks for the video! I have a question: what if the lower bound is negative and the variable cannot take negative numbers? :(

[@jskeshminder4627]

I am glad the video was helpful. You will get a negative lower bound depending on the data that you have collected. However, at this stage you are detecting an outlier (Extreme values or value that does not fit your data).

[@Anonymous-ud8qz]

I'm sorry, but I can't understand a word you are saying

[@TheSridharraj]

worst... not at all working....

[@yixiangharry]

Hello, I have dataset of 22873 and Quartile 1 1.252821638, Quartile 3 2.29402605, InnterQR 1.041204412 Upper Limit3.855832667 , Lower Limit -0.30898498 How how can the lower limit be negative?