Euclidian Distance

[Christina]

Is there a function or some other way to determine Euclidian distance using
Excel? Thanks. _c

 

[Guest]

Is there a function or some other way to determine Euclidian distance using
Excel? Thanks. _c

You just plug the normal equations into Excel. For 2 dimensional space
for example:

d = sqrt((x2-x1)^2 + (y2-y1)^2)

Bill

 

[Guest]

I see no *simple* way to do what you want in Excel. If I were doing
this I would pursue one of two approaches:

1) Write a function to do this using VBA. It looks like a fairly
straight forward two level nested loop in Basic. You'll need to have
some general programming experience though and some knowledge of VBA.

2) Buy a standard statistical package for Excel. Do a quick Google
search on the web for:

"Euclidian Distance" Excel

You'll find a bunch of people selling the software. You might even find
a free version somewhere from one of the universities if you spend
enough time trolling.

Now that I've said that, maybe someone here will pop up with a
blindingly simple way of doing this that I've overlooked.

Good luck...

Bill

 

[Christina]

I see no *simple* way to do what you want in Excel. If I were doing
this I would pursue one of two approaches:

1) Write a function to do this using VBA. It looks like a fairly
straight forward two level nested loop in Basic. You'll need to have
some general programming experience though and some knowledge of VBA.

2) Buy a standard statistical package for Excel. Do a quick Google
search on the web for:

"Euclidian Distance" Excel

You'll find a bunch of people selling the software. You might even find
a free version somewhere from one of the universities if you spend
enough time trolling.

Now that I've said that, maybe someone here will pop up with a
blindingly simple way of doing this that I've overlooked.

Good luck...

Bill

Thanks a lot for your effort. I don't feel so bad now, since we came to the
same conclusion. There were lots of very manual things we could think of,
but nothing *simple*. But I just wanted that "double check" from the
experts!

 

[Matthias Klaey]

Thanks a lot for your effort. I don't feel so bad now, since we came to the
same conclusion. There were lots of very manual things we could think of,
but nothing *simple*. But I just wanted that "double check" from the
experts!

Christina

The formula you give in your original post is the same as the
"population standard deviation".

your formula = STDEVP

It is not quite clear if you want to count in your formula both

(xi - xj)^2 and (xj - xi)^2

If yes, then

your formula = Sqrt(2) * STDEVP

You also may want to check out DSTDEVP because of the grouping.
You probably still will have to some code to loop around the groups.

HTH

Matthias Kläy