Dear Cesar

I think it is possible to do it in Excel by writing the correct formula, but it will be much quicker to use, for example, iGraph package in R. Please take a look to this page http://igraph.org/r/doc/assortativity.html

You can find there both - existed command for R and formula that You can program in Excel

Thanks a lot Albert for your prompt answer;

As I don't know how to use R but only Excel, would you mind translating the following formula into an Excel-friendly one?

sum(jk(e(j,k)-q(j)q(k)), j, k) / sigma(q)^2

Assuming that we have the following columns:

NODE1_name

NODE1_value

NODE2_name

NODE2_value

Another question is can this assortativity coefficient take into account the weight of links? Then we have one last column named LINK_weight

Best regards,

Cesar

Dear Cesar

Well, I never used Excel for this, but i think the simplest case can be solved like this (please see attachment). However, have to say that I checked the results in R and got close, but not exactly the same number. I guess R uses more correct formula, while here in excel I used a simple correl-function. Will be grateful for any corrections.