Excel formula for Euclidean distance

0 votes

This formula is used by a former coworker of mine to perform cluster analysis:

{=SQRT(SUM(($C3:$F3-$C$11:$F$11)^2))} . 

He has no idea why it functions. Its purpose is to determine the separation between a few points. I only get one result when I run the equation without the. I get another when I run it with it.

Normal distance formula: A2 + B2 = C2. I'm assuming this applies to several points in a row. Is this essentially performing each point in each row?

Oct 9 in Others by Kithuzzz
• 20,660 points
148 views

1 answer to this question.

0 votes
Euclidean Norm of a vector of size 'n' = SQRT(SUMSQ(A1:An))

The SUMSQ function is useful to calculate the Euclidean norm in Excel.
answered Oct 9 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Formula for inserting a thumbnail picture into excel cell, based on another cell's value

Here is a really excellent tutorial on ...READ MORE

answered Oct 31 in Others by narikkadan
• 37,660 points
61 views
0 votes
1 answer
0 votes
1 answer

Excel: Formula for compound interest for monthly deposits where deposits increase every year

It's possible that I don't understand how ...READ MORE

answered Nov 26 in Others by narikkadan
• 37,660 points
31 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
210 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
454 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,100 points
405 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,100 points
3,384 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,849 views
0 votes
1 answer

Repeated Multiplication formula for Excel

Fun little problem using some basic maths: =A1*3^ROW(A1) READ MORE

answered Oct 8 in Others by narikkadan
• 37,660 points
62 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP