Manual Local Moran's Index calculation

Discussion created by garynobles on Feb 9, 2014
Dear Forum,

[edit: excel attachment added]

I have been successfully applying the Local Moran's Index (and Gi*) as part of my PhD, but I want to know exactly how the calculation is achieved. I am an archaeologist and I will be writing this in my thesis, so I must present it in a way other non-statisticians can understand it.

I decided to produce a worked example, for Gi* it was simple but I'm having difficulty calculating a single instance of the Local Moran's i (Li).

Thank you in advance for any help you can give me, I really want to crack this as I am just starting my writing up phase (and it's bugging me)!

The ESRI implemented equation is here:

Here is the local neighbourhood (of a larger dataset 11x11 cells), the target cell is 100.


Neighbourhood average = 87.63

Here is my workings, there is an error which I point out as you go through it.

To get Si^2
sum of al the neighbours minus the mean then squared
this is divided by the number of neighbouring cells minus 1 (the target cell)
this calculation is then subtracted from the mean squared

�??(82-87.63)�??^2     =465.88


Si^2 = 465.88/(8-1)-7678.14= -7611.59

We have to take the value of a neighbour and subtract this from the average of neighbours and multiplied by the search radius (wij)


results summed = -0.07

It should equal -11240.16

This would create the calculation:

I-index=  (100-87.63)/(-7611.)* -11240.16=18.27

Which is what ArcGIS produces, where have I gone wrong?

Thanks, Gary