Join Ron Davis for an in-depth discussion in this video Highlighting exceptions, part of Excel Data-Mining Fundamentals.
- And now we'll look at Highlight Exceptions, which is a nice way of saying outayers and this will come in and analyze our data, look at all these columns, and find anything that it sees out of the normal. That is exceptionally high or exceptionally low excetera. Ok so it sees these outlayers down here and the reason it's called Highlight Exceptions if we come back over to the original and scroll on down, it will highlight these things that it finds to be an exceptional value ectetera.
and you can decide whether or not you want to use them or not. Now one thing you want to be aware of with this tool, is occasionally, depending on what operating system you're running, Windows 8, Windows 7, excetera, if you have a theme applied, then the highlighting may or may not work. So if you run into that go over to your personalization on your PC and see what's happening there. Maybe you have to change the background color or allow it to just go to the default theme and see if the highlighting works.
It's just a little oddity with this tool that I have noticed before. Otherwise, this thing works really well.
- Solving business problems with data mining
- Exploring Excel's data-mining algorithms
- Data mining with Excel SQL Server Analysis Services
- Using the Data Preparation tab
- Detecting categories
- Using the Prediction Calculator