MATLAB: Euclidean distance calculation for values from excel sheet

distanceeuclidean

sir, I have values in an excel sheet, which contains 60×3 values, they are x,y,z cordinates for all the 60 points.Now I need to find out the distance : |d(i)|=sqrt((x(k)-x(j))^2+(y(k)-y(j))^2+(z(k)-z(j)^2)), where i=1:60 , j,k are end points of the line segment under consideration, i.e., between these 60 points line segments are considered, for which this distance we are calculating. So j,k can be j=1:59 and k=2:60..

Can you please help me with the code…

Best Answer

If you have the Statistics Toolbox,

doc pdist

Related Solutions

MATLAB: How to calculate euclidean distance for 3 vectors using matlab

You can find the Euclidean distance between two vectors v1 and v2 using norm:

distance = norm(v1-v2);

I don't know how you are importing the sheets, so let's just look at two sheets, with your initial matrix being sheet0 and the other sheets being numbered 1, 2, ...

(Edited to correct error)

sheetdiff = sheet1-sheet0;
npoints = size(sheet0,1);
distance = zeros(npoints,1);
for I = 1:npoints
  distance(I) = norm(sheetdiff(I,:));
end

Now you'll have to put this inside another loop where you look at one sheet at a time.

MATLAB: Finding Distance Between Each Point (not the diagonal distance)

x=XY(:,1); y=XY(:,2);
result=abs(x-x.')+abs(y-y.');

Best Answer

Related Solutions

MATLAB: How to calculate euclidean distance for 3 vectors using matlab

MATLAB: Finding Distance Between Each Point (not the diagonal distance)

Related Question