software

I am trying to get a formula to produce a distance in feet
Example:
ABC
X corrdy corrd
16806.91680.62
27243.67 1509.92 (Dist. Between a1 amp; a2)
36751.07 1319.53 (Dist. Between a2 amp; a3)

The numbers are X amp; Y Coordinates for devices in a CAD program.

I have a formula that I was trying: (ABS(A1-A2) ABS(B3-B2))/12)
But the results don’t match to the distance in the CAD drawing. Or, are my
math skills that bad???
Assuming Column A is the quot;Xquot; coordinates of points and Column B is the quot;Yquot;
coordinates of the same points, as you have them, then the straight line
distance
between the two points, rows 1 and 2, is the hypotenuse of a right triangle
as follows:
One leg is Abs(A2-A1)
The other leg is Abs(B2-B1)
The hypotenuse is the square root of the sum of the squares of the other two
sides.
The hypotenuse is (((Abs(A2-A1))^2 (Abs(B2-B1))^2)^.5)/12
HTH Otto
quot;not brightquot; lt;not gt; wrote in message
...
gt;I am trying to get a formula to produce a distance in feet
gt; Example:
gt; A B C
gt; X corrd y corrd
gt; 1 6806.9 1680.62
gt; 2 7243.67 1509.92 (Dist. Between a1 amp; a2)
gt; 3 6751.07 1319.53 (Dist. Between a2 amp; a3)
gt;
gt; The numbers are X amp; Y Coordinates for devices in a CAD program.
gt;
gt; I have a formula that I was trying: (ABS(A1-A2) ABS(B3-B2))/12)
gt; But the results don't match to the distance in the CAD drawing. Or, are my
gt; math skills that bad???
gt;
gt;
I am sure that you are very bright, maybe a little forgetful:

Remember Pythagoras

D=sqrt((x1-x2)^2 (y1-y2)^2))
--
Gary's Studentquot;not brightquot; wrote:

gt; I am trying to get a formula to produce a distance in feet
gt; Example:
gt; ABC
gt; X corrdy corrd
gt; 16806.91680.62
gt; 27243.67 1509.92 (Dist. Between a1 amp; a2)
gt; 36751.07 1319.53 (Dist. Between a2 amp; a3)
gt;
gt; The numbers are X amp; Y Coordinates for devices in a CAD program.
gt;
gt; I have a formula that I was trying: (ABS(A1-A2) ABS(B3-B2))/12)
gt; But the results don’t match to the distance in the CAD drawing. Or, are my
gt; math skills that bad???
gt;
gt;

Thanks alot

does it matter which one is first (x1-x2 or x2-x1)

quot;Gary''s Studentquot; wrote:

gt; I am sure that you are very bright, maybe a little forgetful:
gt;
gt; Remember Pythagoras
gt;
gt; D=sqrt((x1-x2)^2 (y1-y2)^2))
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;not brightquot; wrote:
gt;
gt; gt; I am trying to get a formula to produce a distance in feet
gt; gt; Example:
gt; gt; ABC
gt; gt; X corrdy corrd
gt; gt; 16806.91680.62
gt; gt; 27243.67 1509.92 (Dist. Between a1 amp; a2)
gt; gt; 36751.07 1319.53 (Dist. Between a2 amp; a3)
gt; gt;
gt; gt; The numbers are X amp; Y Coordinates for devices in a CAD program.
gt; gt;
gt; gt; I have a formula that I was trying: (ABS(A1-A2) ABS(B3-B2))/12)
gt; gt; But the results don’t match to the distance in the CAD drawing. Or, are my
gt; gt; math skills that bad???
gt; gt;
gt; gt;

Since you are squaring the order is unimportant.
3-5 = -2 and -2^2 =4
5-3 = 2 and 2^2 =
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;not brightquot; gt; wrote in message
...
gt; Thanks alot
gt;
gt; does it matter which one is first (x1-x2 or x2-x1)
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt;gt; I am sure that you are very bright, maybe a little forgetful:
gt;gt;
gt;gt; Remember Pythagoras
gt;gt;
gt;gt; D=sqrt((x1-x2)^2 (y1-y2)^2))
gt;gt; --
gt;gt; Gary's Student
gt;gt;
gt;gt;
gt;gt; quot;not brightquot; wrote:
gt;gt;
gt;gt; gt; I am trying to get a formula to produce a distance in feet
gt;gt; gt; Example:
gt;gt; gt; A B C
gt;gt; gt; X corrd y corrd
gt;gt; gt; 1 6806.9 1680.62
gt;gt; gt; 2 7243.67 1509.92 (Dist. Between a1 amp; a2)
gt;gt; gt; 3 6751.07 1319.53 (Dist. Between a2 amp; a3)
gt;gt; gt;
gt;gt; gt; The numbers are X amp; Y Coordinates for devices in a CAD program.
gt;gt; gt;
gt;gt; gt; I have a formula that I was trying: (ABS(A1-A2) ABS(B3-B2))/12)
gt;gt; gt; But the results don't match to the distance in the CAD drawing. Or, are
gt;gt; gt; my
gt;gt; gt; math skills that bad???
gt;gt; gt;
gt;gt; gt;
i am trying tio get distances of 130 varieties with 5 samples each, and the number of parameters are 9, please tell me how i find the mahalanobis distance in excell, i follow the book of Nadranjan (2005),