{"id":8957,"date":"2025-12-09T07:02:29","date_gmt":"2025-12-09T07:02:29","guid":{"rendered":"https:\/\/mailitics.com\/index.php\/2025\/12\/09\/the-machine-learning-advent-calendar-day-8-isolation-forest-in-excel\/"},"modified":"2025-12-09T07:02:29","modified_gmt":"2025-12-09T07:02:29","slug":"the-machine-learning-advent-calendar-day-8-isolation-forest-in-excel","status":"publish","type":"post","link":"https:\/\/mailitics.com\/index.php\/2025\/12\/09\/the-machine-learning-advent-calendar-day-8-isolation-forest-in-excel\/","title":{"rendered":"The Machine Learning \u201cAdvent Calendar\u201d Day 8: Isolation Forest in Excel"},"content":{"rendered":"<p>    The Machine Learning \u201cAdvent Calendar\u201d Day 8: Isolation Forest in Excel<br \/>\n \t<BR><br \/>\n<BR><\/BR><br \/>\n    <!-- no image --><br \/>\n \t<BR><br \/>\n<BR><\/BR><\/p>\n<div>\n<p>Isolation Forest may look technical, but its idea is simple: isolate points using random splits. If a point is isolated quickly, it is an anomaly; if it takes many splits, it is normal.<\/p>\n<p>Using the tiny dataset 1, 2, 3, 9, we can see the logic clearly. We build several random trees, measure how many splits each point needs, average the depths, and convert them into anomaly scores. Short depths become scores close to 1, long depths close to 0.<\/p>\n<p>The Excel implementation is painful, but the algorithm itself is elegant. It scales to many features, makes no assumptions about distributions, and even works with categorical data. Above all, Isolation Forest asks a different question: not \u201cWhat is normal?\u201d, but \u201cHow fast can I isolate this point?\u201d<\/p>\n<p>The post <a href=\"https:\/\/towardsdatascience.com\/the-machine-learning-advent-calendar-day-8-isolation-forest-in-excel\/\">The Machine Learning \u201cAdvent Calendar\u201d Day 8: Isolation Forest in Excel<\/a> appeared first on <a href=\"https:\/\/towardsdatascience.com\/\">Towards Data Science<\/a>.<\/p>\n<\/div>\n<p> \t<BR><br \/>\n <BR><\/BR><br \/>\n    angela shi<br \/>\n \t<BR><br \/>\n<BR><\/BR><br \/>\n<a href=\"https:\/\/towardsdatascience.com\/the-machine-learning-advent-calendar-day-8-isolation-forest-in-excel\/\">Go to original source<\/a><br \/>\n \t<BR><br \/>\n <BR><\/BR><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Machine Learning \u201cAdvent Calendar\u201d Day 8: Isolation Forest in Excel Isolation Forest may look technical, but its idea is simple: isolate points using random splits. If a point is isolated quickly, it is an anomaly; if it takes many splits, it is normal. Using the tiny dataset 1, 2, 3, 9, we can see [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[62,69,83,67,4393,70,238],"tags":[2605,2713,4394],"class_list":["post-8957","post","type-post","status-publish","format-standard","hentry","category-aimldsaimlds","category-artificial-intelligence","category-data-science","category-deep-dives","category-isolation-forests","category-machine-learning","category-statistics","tag-excel","tag-forest","tag-isolation"],"_links":{"self":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/posts\/8957"}],"collection":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/comments?post=8957"}],"version-history":[{"count":0,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/posts\/8957\/revisions"}],"wp:attachment":[{"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/media?parent=8957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/categories?post=8957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mailitics.com\/index.php\/wp-json\/wp\/v2\/tags?post=8957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}