Social Networks: Converting a 2-Mode Matrix to 1-Mode Matrices in Excel

[@kristinekvist7460]

Absolutely saved my thesis, thank you!

[@JamesCookUMA]

Glad it helped!

[@salvon.960]

This lesson is PURE GOLD.

[@cincosystems1451]

Splendid way of explaining this, thank you very much!

[@kasimimadi7458]

Dr. Cook,,,THANK YOU !

[@luisdecastro2081]

When I try following this steps I am getting a formula error, can it be the ' ' ?

[@udaykirank9887]

Sir, I am getting #value this error. once I did step

[@JamesCookUMA]

Hello, uday kiran k. If you sent me an e-mail showing me a screen capture of your situation, I might better be able to help you. My address is [e-mail].

[@விராஜ்குமார்]

Dr. Coook, How do I create a one-mode network from two-mode weighted networks? Is there any way to do that in excel ?

[@JamesCookUMA]

Hi. What's the theory behind your idea?

[@விராஜ்குமார்]

Well I am working on online forum data. In that thread and user are the nodes and connection are weighted by no. of time user talked in a thread.

[@JamesCookUMA]

Hello. That's already one mode data. There is one kind of object: the node. There is one kind of connection: # times user talks on a thread.

[@விராஜ்குமார்]

Sir, In an online forum, anyone can start a thread. So a person starts a thread and others can reply in that thread. There are more than one thread. Threads dont talk to each other and users can't talk to each other directly so its like Davis's South Western Women Event dataset without weights. In our case an user can reply to a thread more than ones which is considered as weights.

[@nordicolee]

thank you for this!!!

[@sfsamkari1549]

THANK YOU SOOOOO MUCH

[@savinglives3482]

very helpful .. i am using for my publication

[@userd062]

you saved me :)

[@JamesCookUMA]

, as when people have saved me! We live in a web of saving.

[@userd062]

@@JamesCookUMA Hi James, thank you very much. I'm still having difficulty organizing a matrix where Target and Source are correlated (they are nodes in an undirected network), but I need to organize them in a p x p matrix. Do you have a video for this?

[@JamesCookUMA]

@@userd062 Hi. When you say Target and Source are correlated, you don't mean there is a statistical correlation between their properties, but instead mean that target and source are related to each other. Is that a correct interpretation?

[@userd062]

​@@JamesCookUMA Sorry for the confusion. I used those terms to describe significant associations between correlated microorganisms. I found a way, thank you very much

[@임선생-m9s]

Thank you Sir. you saved my ass.... >

[@nordicolee]

lol not the repetitive motion injuries