Freeman centralization

Nov 22, 2014 at 12:05 AM
Hi

Does NodeXL not have a way to calculate centralization scores for each group?

Thanks
Santosh
Editor
Dec 29, 2014 at 3:25 PM
Hi Santosh,

You can use these formulas to calculate network centralization:

Centralization (Degree)
=((MAX(Vertices[Degree])COUNTA(Vertices[Degree]))-SUM(Vertices[Degree]))/((COUNTA(Vertices[Degree])-1)(COUNTA(Vertices[Degree])-2))

Centralization (In-Degree)
=((MAX(Vertices[In-Degree])COUNTA(Vertices[In-Degree]))-SUM(Vertices[In-Degree]))/((COUNTA(Vertices[In-Degree])-1)(COUNTA(Vertices[In-Degree])-1))

Centralization (Out-Degree)
=((MAX(Vertices[Out-Degree])
COUNTA(Vertices[Out-Degree]))-SUM(Vertices[Out-Degree]))/((COUNTA(Vertices[Out-Degree])-1)
(COUNTA(Vertices[Out-Degree])-1))
      Itai