Data Set (Calculating Distances With Minkowsky) Using Excel

How to calculate the distance with Minkowsky using Excel is as follows :

The data that we will use is

The formula we will use is as follows :

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

Explanation :

• B3, C3 and so on are columns of numbers in excel
• ^ is a power formula in excel
• C1 is the divisor for powers that have a value of 3, written in the formula is 1/C1 so that 1/3
• C1 is free