How to know direction of point

  • Context: Undergrad 
  • Thread starter Thread starter Zirok
  • Start date Start date
  • Tags Tags
    Direction Point
Click For Summary
SUMMARY

The discussion centers on calculating distances from an intersection point using Excel, specifically addressing the issue of determining the direction of distances d1, d2, d3, and d4 from points A, B, C, and D. A formula for calculating distances in a 2D plane is provided, which is based on the Euclidean distance formula: √((b1 - a1)² + (b2 - a2)²). The user, Zirok, seeks to identify if distance d2 is negative without comparing X and Y coordinates directly, which indicates a misunderstanding of distance calculations, as distances cannot be negative.

PREREQUISITES
  • Understanding of Euclidean distance calculations in a 2D plane
  • Familiarity with Excel formulas and functions
  • Basic knowledge of coordinate geometry
  • Ability to interpret graphical representations of points and distances
NEXT STEPS
  • Research the properties of Euclidean distance in geometry
  • Learn advanced Excel functions for geometric calculations
  • Explore methods for visualizing point relationships in 2D space
  • Investigate alternative distance metrics, such as Manhattan distance
USEFUL FOR

This discussion is beneficial for mathematicians, data analysts, and anyone involved in spatial analysis or geometric computations using Excel.

Zirok
Messages
6
Reaction score
0
hI,

Refering to the attachment, we have set of points A,B,C,D which intersects at a point (Refer Figure)

I have written a formula in excel to calculate distance d1,d2,d3,d4 from this intersection point.

How would i know that d2 distance is negative ( or in a reverse position) without actually comparing the X,Y positions with respect to Intersection Point.

Is there any other way to do it. ?

Thanks
Zirok
 

Attachments

  • ABCD.JPG
    ABCD.JPG
    16.6 KB · Views: 546
Mathematics news on Phys.org
Your attachment is pending approval, so I don't know the details of your problem.

You should not get a negative distance, so if you are, you are doing something wrong. Assuming that your points are in the plane, the distance from a point A(a, a2) to point B(b1, b2) is
[tex]\sqrt{(b_1 - a_1)^2 + (b_2 - a_2)^2}[/tex].
 

Similar threads

  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 7 ·
Replies
7
Views
2K
  • · Replies 13 ·
Replies
13
Views
3K
  • · Replies 4 ·
Replies
4
Views
2K
  • · Replies 3 ·
Replies
3
Views
5K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 27 ·
Replies
27
Views
2K