Calculate rWG(j), ICC(1), and ICC(2) in Excel
HTML-код
- Опубликовано: 22 авг 2024
- Calculate rWG(j), ICC(1), and ICC(2) in Excel using the tool created by Biemann & Cole, 2012.
Link to Michael S. Cole Website: www.neeley.tcu...
"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."
I have been given permission to host this document from Michael Cole. PLEASE DOWNLOAD THE FILE. DO NOT REQUEST EDIT PERMISSION. psychologyofbu...
I have been given permission to host this document from Michael Cole. psychologyofbusiness.beehiiv.com/p/comparing-and-calculating-reliability-measuresmultilevel-models-understanding-rwgj-icc1-icc2
Nice lecture. Thanks.
Thank you.
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.
You should be able to change how many responses items are on the scale by inputting your # of response items. (7 point likert scale, 5 point, 4 point, etc).
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
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!
Hello. You must download the file for personal use. Windows 11 has issues with macros (see my other video). Also, I have heard there are issues running it on PC.
@@BrandonPhD thank you for your reply. I dowloaded the file in my Windows 11 PC, enabled macros, opened the file locally, but no macro was assigned. I guess there is nothing else I can do. Thank you.
@xmamakou perhaps reach out to the original author of the paper. Good luck!!
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.
I am not sure. You may want to reach out to the original creators of the tool.
I use to have this important tool but lost it. Is it possible to be sent it privately Brandon?
Send me an email and I will send it privately.
Hi Professor,
Can you please send the Excel file for calculating rWG and ICC to me? Thank you
Send me an email and I will send it privately.
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
Hello, please download a copy for your personal use. Try file > download.
Hi Brandon, that worked perfectly! Thank you. When I go to open the file, I enable macros but it still says that this workbook contains content that isn't supported in this version of Excel Avtive X. Is there any way around this? Ive tried updating excel on my mac and that has not helped the problem. thank you again!
@nici7228 I am not 100% sure, but there may be issues with it running on Mac.
ah ok thank you so very much. Let me try and see if it works on a windows laptop instead. thank you again. This video has saved my research!!@@BrandonPhD
hello sir, Can you please send the Excel file for calculating rWG and ICC to me? Thank you.
Hello. Please download for personal use from here. psychologyofbusiness.beehiiv.com/p/comparing-and-calculating-reliability-measuresmultilevel-models-understanding-rwgj-icc1-icc2
Hi thank you so much for such an insightful video. Please provide me with the excel file. Thank you
hello sir, my research consists of 39 items, do you have any way to handle more-than-22-item research ? Thank you sir
I do not. Reach out to the author of this tool.
@@BrandonPhD Can you help me how I can reach out to the author please?
Hello, Professor Brandon; your lecture is beneficial. Is it possible to send an Excel file privately?
Download for personal use.
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?
Are you on a Mac or a PC? I have heard that a Mac has issues with the software.
@@BrandonPhD It's PC
I'm not sure how to fix this. I badly need to calculate my ICCs to do the further analysis 😥
@@farzanaashraf4661 Did you solve your issue with ICC calculation
Hey, I am wondering if this program is also working with IOS?
Likely not. I’ve heard it only works on PC.