Calculate rWG(j), ICC(1), and ICC(2) in Excel

Calculate rWG(j), ICC(1), and ICC(2) in Excel using the tool created by Biemann & Cole, 2012.

"This is a tool designed to accompany: Biemann, T., Cole, M. S., & Voelpel, S. (2012). Within-group agreement: On the use (and misuse) of rwg and rwg(j) in leadership research and some best practice guidelines. The Leadership Quarterly, 23, 66-80."

"An Excel 2007 Tool for Computing Interrater Agreement (IRA) & Interrater Reliability (IRR) Estimates for Consensus Composition Constructs."

[ymmichael]

This is a wonderful tool! Does the single-item rwg tab allow for items with 4 levels? I see the multiple item rwg(j) requires between 5-11 levels.

[xmamakou]

Hello! Thank you for the video and the file. Unfortunately, I am facing a problem making it work. I downloaded it and enabled macros, but it seems that the macros are not associated with any of the buttons. Moreover, the radio buttons on the "input" sheet are not there (they are missing from the online file as well). Could you please check if there is a problem with the online file? Is there any chance you could re-upload it? Thank you very much!

[PinjungNawangSari]

Dear Prof. Brandon, thank you so much for giving us this importance lecture. I've downloaded the Excel file, unblock the Macros, but still cannot operate the process instruction (it's only read as a picture in my Office). I've been using laptop and PC, but still. Could you please help me to solve this problem? Thank you in advance

[farzanaashraf]

Hi Brandon, thanks a lot for this. I am facing an issue in running the macros. I have enabled macros both on excel and from properties. Then again, whenever I open this file, it asks me to assign macros from a list. Could you please help?

[FabehaShahzad]

hello sir, Can you please send the Excel file for calculating rWG and ICC to me? Thank you.

[zahid]

Hello, Professor Brandon; your lecture is beneficial. Is it possible to send an Excel file privately?

[adeogunsanya]

Hi Professor,
Can you please send the Excel file for calculating rWG and ICC to me? Thank you

[stevenbayig]

I use to have this important tool but lost it. Is it possible to be sent it privately Brandon?

[杜俊甫-iq]

Hi, Prefessor Brandon, why doesn't the .xlsm file I downloaded have the 'calculate team values' macro? I only have 9 macros available for use. Thank you.

[khangnguyen]

hello sir, my research consists of 39 items, do you have any way to handle more-than-22-item research ? Thank you sir

[nici]

Hi Brandon, Thank you so much for this video! It has saved my life. I have found the tool from the hyperlink you have pinned. Is there a way for me to save it onto my excel to use for my own data? It appears to be a read only file on safari at the moment? Thank you again

[shagunsarraf]

Hi thank you so much for such an insightful video. Please provide me with the excel file. Thank you

[YaraWewerinke]

Hey, I am wondering if this program is also working with IOS?