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.
This download is for Registered Users Only.
Perhaps you need to login or register.