| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate minimum distance between three coordinate withex
x = list of x coordinates
y = list of y coordinates avgx=AVERAGE(x) avgy=AVERAGE(y) cov=COVAR(x,y) varx=VARP(x) vary=VARP(y) d=2*(varx*vary-cov^2) avgu=AVERAGE(((x-avgx)^2+(y-avgy)^2)*(x-avgx)) (an array formula-CSE) avgv=AVERAGE(((x-avgx)^2+(y-avgy)^2)*(y-avgy)) (an array formula-CSE) cx= avgx+(avgu*vary-avgv*cov)/d (x coordinate of center) cy= avgy+(avgv*varx-avgu*cov)/d (y coordinate of center) Kudos to Greg Egan at group comp.graphics.algorithms |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can excel calculate Mahalanobis distance? | Excel Discussion (Misc queries) | |||
| Minimum Distance Calculation using Array and Geographical Coordinates | Excel Discussion (Misc queries) | |||
| How to calculate speed given distance and mm:ss time format? | Excel Discussion (Misc queries) | |||
| Calculate Minimum numbers | Excel Worksheet Functions | |||
| CALCULATE DISTANCE BETWEEN TWO GPS POSITIONS | Excel Worksheet Functions | |||
Hybrid Mode
