Mahalanobis distance matrix of an excel dataset

i have an excel dataset with 7 column and 20 rows . i want to know how to compute and get the mahalanobis distance matrix in matlab.

Answer 1

[Akira Agata]

Like this?

% Read data from Excel file
Data = xlsread('yourExcelFile.xlsx');

% Calculate pair-wise mahalanobis distance
D = pdist(Data,'mahalanobis');

% Convert to square form
D = squareform(D);

[Mmotevasseli(alex)]

what should i do if i want use formula of mahalanobis in my code and dont use pdist?

[Akira Agata]

In that case, maybe you have to implement mahalanobis-based pdist function by yourself using basic MATLAB function...

The definition of mahalanobis distance used in pdist function can be found in the pdist help page:

https://jp.mathworks.com/help/stats/pdist.html#mw_238ce485-9126-46a1-beaa-f2dcc12573eb