Distance Formula: Given the two points (x1, y1) and (x2 ...
Using the Distance Formula
Distance Formula: Given the two points (x1, y1) and (x2, y2), the distance between these points is given by the formula:
[pic]
Open up an excel worksheet label the top row cells as:
| x1 | y1 | x2 | y2 |(x2 - x1)2 |(y2 - y1)2 | |
Enter the coordinates (1,1) and (4,5) the 5th cell enter =(C2-A2)^2
6th cell enter =(D2-B2)^2
7th cell enter =SQRT(E2+F2)
The second row in the excel sheet should have the values:
| 1 | 1 | 4 | 5 | 9 | 16 | 5 |
Assignment: Use the distance formula to decide whether [pic] [pic] [pic]
1) P(4,-4) 2) P(-1,-6) 3)P(5,1) 4) P(-2,0)
Q(1,-6) Q(-8,5) Q(-5,-7) Q(10,-14)
R(-1,-3) R(3,-2) R(-3,6) R(-4,-2)
Find the distance between the two cities using the information in the table, which is from a coordinate system used for calculating long-distance telephone rates.
|Buffalo, NY |(5075,2326) |Omaha, NE |(6687, 4595) |
|Chicago, IL |(5986, 3426) |Providence, RI |(4550, 1219) |
|Dallas, TX |(8436, 4034) |San Diego, CA |(9468, 7629) |
|Miami, FL |(8351, 527) |Seattle, WA |(6336, 8896) |
5) Buffalo and Dallas
6) Chicago and Seattle
7) Miami and Omaha
8) Providence and San Diego
9) Buffalo and Providence
10) Use the excel chart wizard to graph and label the points A(-4,7) B(6,2) C(3,-2) then find the distance between each pair of points
-----------------------
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- excel exercise the one input data table
- microsoft excel tutorial 1
- use excel as your calculator further education support
- distance formula given the two points x1 y1 and x2
- flight planners for microsoft excel 7 0
- template for developing sewer collection system preventive
- excel key terms
- exceltm and statistical analysis
Related searches
- distance between two points map
- distance between two points calculator 3d
- distance between two points geometry
- distance between two points 3d
- average acceleration formula given time and distance
- distance between two points python
- what is the distance formula calculator
- distance between two points 3 dimensions
- find the distance between the two points
- find x1 and x2 matrix calculator
- what is the distance formula geometry
- distance between two points algebra