
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 indegree and outdegree gives the number of uniques (not duplicate) connections. I want to identify the vertice with more connections, unique and duplicated.
Paula


Aug 6, 2014 at 6:27 AM
Edited Aug 7, 2014 at 12:35 AM

Paula:
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 thatit'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


Coordinator
Aug 12, 2014 at 5:38 PM

Hello!
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 inedges and outedges terminating or originating with the Target Vertex.

Marc



Thanks Marc.
It works.

