>>113
I'm a dumbass, it's actually
minkowski distance
Anyways, for the euclidian distance, apparently you do:
(x1−y1)2+(x2−y2)2
or for those playing along in calc,
=SQRT((B$3-B3)^2+(C$3-C3)^2)
and apply to the appropriate cells.
⎣⎡0.02.83.25.12.80.01.43.23.21.40.02.05.13.22.00.0⎦⎤
Since i was working in calc, the table containing the data spans over the
B3:C6
range
Then, for the minkowski distance, there's something called the P value, and if it's equal to 1, then it becomes the manhattan distance, so in this example the equation would be
∣x1−y1∣ + ∣x2−y2∣
and the corresponding calc formula for a particular cell (i'm not saying which one hehe)
=(($B$3-$B3)^1+($C$3-$C3)^1)^(1/RIGHT($E$14,1))
⎣⎡00−2−400−2−4220−24420⎦⎤
And for the cosine similarity or distance idk, just do a vector dot product
∣x∣⋅∣y∣x⋅y
This time it was a bit more difficult in calc, and the formula for the left upper cell is
=SUMPRODUCT(B$3:C$3,B3:C3)/(SQRT(SUMSQ(B$3:C$3))*SQRT(SUMSQ(B3:C3)))
⎣⎡1.000.000.320.200.001.000.950.980.320.951.000.990.200.980.991.00⎦⎤
Cool.