• About Us
  • Privacy Policy
  • Disclaimer
  • Contact Us
TechTrendFeed
  • Home
  • Tech News
  • Cybersecurity
  • Software
  • Gaming
  • Machine Learning
  • Smart Home & IoT
No Result
View All Result
  • Home
  • Tech News
  • Cybersecurity
  • Software
  • Gaming
  • Machine Learning
  • Smart Home & IoT
No Result
View All Result
TechTrendFeed
No Result
View All Result

The Machine Studying “Creation Calendar” Day 9: LOF in Excel

Admin by Admin
December 10, 2025
Home Machine Learning
Share on FacebookShare on Twitter


Yesterday, we labored with Isolation Forest, which is an Anomaly Detection methodology.

Immediately, we have a look at one other algorithm that has the identical goal. However in contrast to Isolation Forest, it does not construct timber.

It’s known as LOF, or Native Outlier Issue.

Individuals usually summarize LOF with one sentence: Does this level reside in a area with a decrease density than its neighbors?

This sentence is definitely tough to know. I struggled with it for a very long time.

Nonetheless, there’s one half that’s instantly simple to know,
and we’ll see that it turns into the important thing level:
there’s a notion of neighbors.

And as quickly as we speak about neighbors,
we naturally return to distance-based fashions.

We are going to clarify this algorithm in 3 steps.

To maintain issues quite simple, we’ll use this dataset, once more:

1, 2, 3, 9

Do you keep in mind that I’ve the copyright on this dataset? We did Isolation Forest with it, and we’ll do LOF with it once more. And we will additionally evaluate the 2 outcomes.

LOF in Excel with 3 steps- all photographs by creator

All of the Excel information can be found via this Kofi hyperlink. Your assist means quite a bit to me. The value will enhance throughout the month, so early supporters get the very best worth.

All Excel/Google sheet information for ML and DL

Step 1 – ok Neighbors and k-distance

LOF begins with one thing very simple:

Take a look at the distances between factors.
Then discover the ok nearest neighbors of every level.

Allow us to take ok = 2, simply to maintain issues minimal.

Nearest neighbors for every level

  • Level 1 → neighbors: 2 and three
  • Level 2 → neighbors: 1 and three
  • Level 3 → neighbors: 2 and 1
  • Level 9 → neighbors: 3 and a couple of

Already, we see a transparent construction rising:

  • 1, 2, and three kind a good cluster
  • 9 lives alone, removed from the others

The k-distance: an area radius

The k-distance is just the most important distance among the many ok nearest neighbors.

And that is really the important thing level.

As a result of this single quantity tells you one thing very concrete:
the native radius across the level.

If k-distance is small, the purpose is in a dense space.
If k-distance is massive, the purpose is in a sparse space.

With simply this one measure, you have already got a primary sign of “isolation”.

Right here, we use the thought of “ok nearest neighbors”, which in fact reminds us of k-NN (the classifier or regressor).
The context right here is completely different, however the calculation is precisely the identical.

And if you happen to consider k-means, don’t combine them:
the “ok” in k-means has nothing to do with the “ok” right here.

The k-distance calculation

For level 1, the 2 nearest neighbors are 2 and 3 (distances 1 and a couple of), so k-distance(1) = 2.

For level 2, neighbors are 1 and 3 (each at distance 1), so k-distance(2) = 1.

For level 3, the 2 nearest neighbors are 1 and 2 (distances 2 and 1), so k-distance(3) = 2.

For level 9, neighbors are 3 and 2 (6 and seven), so k-distance(9) = 7. That is large in comparison with all of the others.

In Excel, we will do a pairwise distance matrix to get the k-distance for every level.

LOF in Excel – picture by creator

Step 2 – Reachability Distances

For this step, I’ll simply outline the calculations right here, and apply the formulation in Excel. As a result of, to be sincere, I by no means succeeded to find a very intuitive technique to clarify the outcomes.

So, what’s “reachability distance”?

For some extent p and a neighbor o, we outline this reachability distance as:

reach-dist(p, o) = max(k-dist(o), distance(p, o))

Why take the utmost?

The aim of reachability distance is to stabilize density comparability.

If the neighbor o lives in a really dense area (small k-dist), then we don’t wish to permit an unrealistically small distance.

Particularly, for level 2:

  • Distance to 1 = 1, however k-distance(1) = 2 → reach-dist(2, 1) = 2
  • Distance to three = 1, however k-distance(3) = 2 → reach-dist(2, 3) = 2

Each neighbors power the reachability distance upward.

In Excel, we’ll hold a matrix format to show the reachability distances: one level in comparison with all of the others.

LOF in Excel – picture by creator

Common reachability distance

For every level, we will now compute the common worth, which tells us: on common, how far do I must journey to achieve my native neighborhood?

And now, do you discover one thing: the purpose 2 has a bigger common reachability distance than 1 and three.

This isn’t that intuitive to me!

Step 3 – LRD and the LOF Rating

The ultimate step is type of a “normalization” to seek out an anomaly rating.

First, we outline the LRD, Native Reachability Density, which is just the inverse of the common reachability distance.

And the ultimate LOF rating is calculated as:

So, LOF compares the density of some extent to the density of its neighbors.

Interpretation:

  • If LRD(p) ≈ LRD (neighbors), then LOF ≈ 1
  • If LRD(p) is way smaller, then LOF >> 1. So p is in a sparse area
  • If LRD(p) is way bigger → LOF < 1. So p is in a really dense pocket.

I additionally did a model with extra developments, and shorter formulation.

Understanding What “Anomaly” Means in Unsupervised Fashions

In unsupervised studying, there isn’t a floor reality. And that is precisely the place issues can turn into tough.

We should not have labels.
We should not have the “appropriate reply”.
We solely have the construction of the information.

Take this tiny pattern:

1, 2, 3, 7, 8, 12
(I even have the copyright on it.)

In the event you have a look at it intuitively, which one looks like an anomaly?

Personally, I’d say 12.

Now allow us to have a look at the outcomes. LOF says the outlier is 7.

(And you may discover that with k-distance, we’d say that it’s 12.)

LOF in Excel – picture by creator

Now, we will evaluate Isolation Forest and LOF aspect by aspect.

On the left, with the dataset 1, 2, 3, 9, each strategies agree:
9 is the clear outlier.
Isolation Forest offers it the bottom rating,
and LOF offers it the very best LOF worth.

If we glance nearer, for Isolation Forest: 1, 2 and three haven’t any variations in rating. And LOF offers a better rating for two. That is what we already seen.

With the dataset 1, 2, 3, 7, 8, 12, the story modifications.

  • Isolation Forest factors to 12 as probably the most remoted level.
    This matches the instinct: 12 is way from everybody.
  • LOF, nonetheless, highlights 7 as a substitute.
LOF in Excel – picture by creator

So who is true?

It’s troublesome to say.

In observe, we first must agree with enterprise groups on what “anomaly” really means within the context of our information.

As a result of in unsupervised studying, there isn’t a single reality.

There’s solely the definition of “anomaly” that every algorithm makes use of.

For this reason this can be very vital to know
how the algorithm works, and how much anomalies it’s designed to detect.

Solely then are you able to resolve whether or not LOF, or k-distance, or Isolation Forest is the fitting selection in your particular state of affairs.

And that is the entire message of unsupervised studying:

Completely different algorithms have a look at the information in another way.
There isn’t a “true” outlier.
Solely the definition of what an outlier means for every mannequin.

For this reason understanding how the algorithm works
is extra vital than the ultimate rating it produces.

LOF Is Not Actually a Mannequin

There’s yet one more level to make clear about LOF.

LOF doesn’t study a mannequin within the common sense.

For instance

  • k-means learns and retailer centroids (means)
  • GMM learns and retailer means and variances
  • resolution timber, study and retailer guidelines

All of those produce a operate you could apply to new information.

And LOF doesn’t produce such a operate. It relies upon fully on the neighborhood construction contained in the dataset. In the event you add or take away some extent, the neighborhood modifications, the densities change, and the LOF values have to be recalculated.

Even if you happen to hold the entire dataset, like k-NN does, you continue to can not apply LOF safely to new inputs. The definition itself doesn’t generalize.

Conclusion

LOF and Isolation Forest each detect anomalies, however they have a look at the information via fully completely different lenses.

  • k-distance captures how far some extent should journey to seek out its neighbors.
  • LOF compares native densities.
  • Isolation Forest isolates factors utilizing random splits.

And even on quite simple datasets, these strategies can disagree.
One algorithm might flag some extent as an outlier, whereas one other highlights a very completely different one.

And that is the important thing message:

In unsupervised studying, there isn’t a “true” outlier.
Every algorithm defines anomalies in response to its personal logic.

For this reason understanding how a way works is extra vital than the quantity it produces.
Solely then are you able to select the fitting algorithm for the fitting state of affairs, and interpret the outcomes with confidence.

Tags: AdventcalendarDayExcelLearningLOFMachine
Admin

Admin

Next Post
Saviynt Raises $700M at Roughly $3B Valuation

Saviynt Raises $700M at Roughly $3B Valuation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Trending.

Reconeyez Launches New Web site | SDM Journal

Reconeyez Launches New Web site | SDM Journal

May 15, 2025
Safety Amplified: Audio’s Affect Speaks Volumes About Preventive Safety

Safety Amplified: Audio’s Affect Speaks Volumes About Preventive Safety

May 18, 2025
Flip Your Toilet Right into a Good Oasis

Flip Your Toilet Right into a Good Oasis

May 15, 2025
Apollo joins the Works With House Assistant Program

Apollo joins the Works With House Assistant Program

May 17, 2025
Discover Vibrant Spring 2025 Kitchen Decor Colours and Equipment – Chefio

Discover Vibrant Spring 2025 Kitchen Decor Colours and Equipment – Chefio

May 17, 2025

TechTrendFeed

Welcome to TechTrendFeed, your go-to source for the latest news and insights from the world of technology. Our mission is to bring you the most relevant and up-to-date information on everything tech-related, from machine learning and artificial intelligence to cybersecurity, gaming, and the exciting world of smart home technology and IoT.

Categories

  • Cybersecurity
  • Gaming
  • Machine Learning
  • Smart Home & IoT
  • Software
  • Tech News

Recent News

Fitbit’s Gemini-Powered Coach Is Coming to iPhone and Different International locations

Fitbit’s Gemini-Powered Coach Is Coming to iPhone and Different International locations

February 11, 2026
Steps to Embrace Sustainable and Eco-Pleasant Kitchen Merchandise for Conscious Homemakers – Chefio

Steps to Embrace Sustainable and Eco-Pleasant Kitchen Merchandise for Conscious Homemakers – Chefio

February 11, 2026
  • About Us
  • Privacy Policy
  • Disclaimer
  • Contact Us

© 2025 https://techtrendfeed.com/ - All Rights Reserved

No Result
View All Result
  • Home
  • Tech News
  • Cybersecurity
  • Software
  • Gaming
  • Machine Learning
  • Smart Home & IoT

© 2025 https://techtrendfeed.com/ - All Rights Reserved