Line between two point and perpendicular distance to third point.xls

Rating:
3

Description


Purpose of calculation:
a) Find the equation of a line through two points.
b) Calculate the shortest distance between the line and a third point.
Calculation Reference
First principles and proof on http://math.ucsd.edu/~wgarner/math4c/derivations/distance/distptline.htm
Calculation Validation
Independent check and graphical check.

The following video describes how to use the spreadsheet. It is best viewed in fullscreen mode so you will have to double click the player.

Calculation Reference
Co-ordinate Geometry
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Submitted On:
03 Sep 2008
File Size:
41.00 Kb
Downloads:
194
File Version:
1.0
File Author:
John Doyle
Rating:
3

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 2
questio 14 years ago
Just what I was looking for, and no does the job, simply and perfectly.
Thanks!
questio 14 years ago
Just what I was looking for, and no does the job, simply and perfectly.
Thanks!