graph metrics

Aug 3, 2014 at 5:57 PM
I would like to know if it is possible, in Node XL, know which is the vertex with the largest number of connections (whether the connections are unique or not), in directional graph.

The in-degree and out-degree gives the number of uniques (not duplicate) connections. I want to identify the vertice with more connections, unique and duplicated.

Aug 6, 2014 at 5:27 AM
Edited Aug 6, 2014 at 11:35 PM

I don't know how to do that.

NodeXL does indeed skip duplicate edges when it calculates degree metrics. I don't know why it does that--it's done it for years and no one has pointed it out. If anyone has an opinion on whether this is a design error or if it's the correct way to do it, please let us know.

-- Tony
Aug 12, 2014 at 4:38 PM

NodeXL does generate a count of alters not edges.

However, a count of edges can be created using a few Excel formulas.

The COUNTIF() function can be used to count the number of edges that have the Target Vertex in the Vertex 1 column. A separate formula can count the incidence of the Target Vertex in the Vertex 2 column.

Add these columns together to get the count of the total in-edges and out-edges terminating or originating with the Target Vertex.


Aug 12, 2014 at 5:28 PM
Thanks Marc.

It works.