Using Random Number Functions in Excel for Managing Research – Recorded Livestream
Channel: Monika Wahi
Date: 26/03/2022

*Note: I may be compensated, but you will not be charged, if you click on the links below.

This livestream originally was broadcast on March 26, 2022. Monika demonstrates using rand() and randbetween() in Excel for research management. She demonstrates:
* How to randomize records
* How to de-identify records and make a study ID crosswalk
* How to do a blocked randomization
Monika demonstrates using hospital data from the American Hospital Directory: https://www.ahd.com/ 
Github link to Excel sheet created during livestream: https://buff.ly/3ryoSCv 

I listed the links I mention below as they come up in the livestream. Enjoy!
04:18 Beginning of the stream – please help Monika expand her audience by liking this video (if you like it), and subscribing to her channel if you want to see more!
05:36 LinkedIn Learning course: Marketing and Monetizing on YouTube: https://linkedin-learning.pxf.io/rn0zaD
06:00 Message to learners doing portfolio projects for data science and posting videos on YouTube – description is important for SEO (and for your audience’s experience)
07:35 Essentials of Statistics playlist: https://buff.ly/30HufFk
09:07 Use case description: random number functions in Excel for managing research
10:08 Explanation of American Hospital Directory web site, and quarterly Medicare data reporting
12:45 Reviewing meanings of columns in demo dataset
14:48 Lecture: U.S. Health Care: Financing and Reimbursement Methods: https://youtu.be/3PVSYPDcBOo 
15:30 Description of the research activities that take place in a clinical trial before randomization: recruitment, eligibility, consent, and baseline measurements.
16:28 Rationale for assigning a random unique Study ID number to participants in an observational study
18:16 Inserting an Order column
19:00 Adding a sequentially-numbered column through dragging
20:08 Demonstration of unfreeze panes and freeze panes
21:50 Use case: Adding a random Study ID to participant records in an observational study
22:17 Demonstration of =rand()
25:06 Strategy for keeping human participants de-identified using a Study ID in online surveys
26:47 Strategies for randomizing study IDs for keeping double-blind in a medication clinical trial
28:33 Challenges with unblinding in a double-blind clinical trial
29:25 Demonstration of making a Study ID crosswalk (xwalk)
33:44 Demonstration of =randbetween()
38:00 Review of difference between observational studies and clinical trials
39:22 Description of the counterfactual and how the randomization sees study participants
41:20 Rationale for randomizing at a group level, and how this relates to machine learning/artificial intelligence
43:18 Dr. Bob’s study where Monika helped him randomize the participants: https://pubmed.ncbi.nlm.nih.gov/17949779/
44:50 Demonstration of randomizing records and placing them in two different treatment groups
48:42 Updating Study ID crosswalk (xwalk) with treatment assignment
50:03 Issues with imbalance on a factor in simple random sampling (SRS) with small data. Watch Monika’s lecture on sampling: https://youtu.be/wNwK34GcmiQ
52:23 Demonstration of solving the imbalance by doing a blocked randomization.
01:00:00 Using Excel as a “sandbox” to work out how it would be done in SAS or R
01:01:21 Shoutout to research administration skills – take Monika’s data curation course: https://linkedin-learning.pxf.io/ZnNeq

WANT TO SUPPORT MONIKA? FOLLOW HER ON SOCIAL MEDIA!
Check out Monika's courses on LinkedIn Learning: https://linkedin-learning.pxf.io/NKN0JO 
Follow Monika on LinkedIn for updates and to know about future live streams: https://www.linkedin.com/in/dethwench/  
Subscribe to Monika's YouTube channel: https://buff.ly/2W6ijuc  
Sign up for Monika’s weekly e-newsletter with links to data science learning resources: https://dethwench.com/get-data-science-newsletter/ 
Follow Monika's educational feed on Twitter: https://twitter.com/PHExaminer  
Follow Monika's data science blog: https://dethwench.com/blog/
Check out Monika's book "Mastering SAS Programming for Data Warehousing": https://buff.ly/31Hz1mg