Thread: Can excel calculate Mahalanobis distance?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
  
Posts: 1,397
Default Can excel calculate Mahalanobis distance?
I Know of no add-in, but
(if I understand Mahalanobis distance properly)

=sumproduct((range1*range2)^L)^(1/L)
may work
where range1 and 2 are your comparison data and L is the Mahalanobis level
you wish
"kt_b1" wrote:

Is there an option in excel add-inns for Mahalanobis distance? or can it be
programmed to calculate this? If so, how?
Reply With QuoteReply With Quote