Line between two point and perpendicular distance to third point.xls
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 |
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.
Thanks!
Thanks!