Data Sets (Calculating Distances With Euclidean) Using Excel
How to calculate the distance with Euclidean using Excel is as follows:
The data that we will use is
The formula we will use is as follows:
- =SQRT((B3-C3)^2+(B4-C4)^2+(B5-C5)^2+(B6-C6)^2+(B7-C7)^2)
- = 6.782329983
Explanation :
- SQRT is a formula in excel for roots
- B3, C3 and so on are columns of numbers in excel
- ^ is a power formula in excel
Tidak ada komentar:
Posting Komentar