Data Set (Calculating Distance With Manhattan) Using Excel

How to calculate the distance to Manhattan using Excel is as follows:

The data that we will use is

The formula we will use is as follows:

• =ABS((B3-C3)+(B4-C4)+(B5-C5)+(B6-C6)+(B7-C7))
• 1

The result should be -1, because for the calculation of the Manhattan distance it must have an absolute value. Then the value -1 has a house of 1

Explanation :

• ABS is a formula in excel for absolute numbers
• B3, C3 and so on are columns of numbers in excel