Line between two point and perpendicular distance to third point.xls
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.
First principles and proof on http://math.ucsd.edu/~wgarner/math4c/derivations/distance/distptline.htm
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.
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
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.