{"id":5834,"date":"2016-07-15T22:42:16","date_gmt":"2016-07-15T17:12:16","guid":{"rendered":"https:\/\/medicosplexus.com\/?p=5834"},"modified":"2016-07-15T22:42:16","modified_gmt":"2016-07-15T17:12:16","slug":"block-randomization-clinical-trials-video-tutorial-microsoft-excel","status":"publish","type":"post","link":"https:\/\/medicosplexus.com\/block-randomization-clinical-trials-video-tutorial-microsoft-excel\/","title":{"rendered":"Block Randomization in Clinical Trials: Video Tutorial in Microsoft Excel"},"content":{"rendered":"<p><iframe loading=\"lazy\" title=\"Block Randomization in Clinical Trials: Video Tutorial in Microsoft Excel\" width=\"1020\" height=\"574\" src=\"https:\/\/www.youtube.com\/embed\/q1xJ9kqw6vo?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p>This is a video tutorial on how to do block randomization in clinical trials\/ studies. This is a very common way of randomization in research studies.<br \/>\nI have explained mainly of block randomization of a group of 2 in Microsoft excel. I have also mentioned briefly about block randomization with a group of 4.<\/p>\n<p>Steps to be followed:<\/p>\n<ol>\n<li>Number the participants from 1 to n.<\/li>\n<li>Divide each participant into groups starting from 1. Easiest is to divide into groups of 2. As the possible combinations are easy to know. e.g. In a group of 2, the possible combinations of blocks are PT &amp; TP. (P = Placebo, T = Test). This can be changed depending on a number of groups and number of volunteers. In case of group \u00a0of 4, number of possible blocks are 6. e.g. A &amp; B are groups then possible blocks are<br \/>\n<table style=\"border-collapse: collapse; width: 48pt;\" border=\"0\" width=\"64\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col style=\"width: 48pt;\" width=\"64\" \/> <\/colgroup>\n<tbody>\n<tr style=\"height: 14.5pt;\">\n<td style=\"height: 14.5pt; width: 48pt;\" width=\"64\" height=\"19\">ABBA<\/td>\n<\/tr>\n<tr style=\"height: 14.5pt;\">\n<td style=\"height: 14.5pt;\" height=\"19\">ABAB<\/td>\n<\/tr>\n<tr style=\"height: 14.5pt;\">\n<td style=\"height: 14.5pt;\" height=\"19\">BBAA<\/td>\n<\/tr>\n<tr style=\"height: 14.5pt;\">\n<td style=\"height: 14.5pt;\" height=\"19\">ABAB<\/td>\n<\/tr>\n<tr style=\"height: 14.5pt;\">\n<td style=\"height: 14.5pt;\" height=\"19\">BAAB<\/td>\n<\/tr>\n<tr style=\"height: 14.5pt;\">\n<td style=\"height: 14.5pt;\" height=\"19\">BABA<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/li>\n<li>Then divide\u00a0the total number of volunteers\/ patients by number in each group. i.e. n\/2 or n\/4 in my examples. You will now get a total number of groups.<\/li>\n<li>Now allot a block to each group e.g. Group 1 = PT, Group 2 = TP, Group 3 PT and so on.<\/li>\n<li>And now insert RAND function it the next column and filter to sort the random numbers which are inserted as shown in the video.<\/li>\n<li>Allot the treatment groups to volunteers\/ patients according to the randomization done.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>This is a video tutorial on how to do block randomization in clinical trials\/ studies. This is a very common way of randomization in research studies. I have explained mainly of block randomization of a group of 2 in Microsoft excel. I have also mentioned briefly about block randomization with a group of 4. Steps [&#8230;]\n","protected":false},"author":7,"featured_media":5835,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[2],"tags":[36,141,145,161],"_links":{"self":[{"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/posts\/5834"}],"collection":[{"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/comments?post=5834"}],"version-history":[{"count":0,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/posts\/5834\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/media\/5835"}],"wp:attachment":[{"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/media?parent=5834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/categories?post=5834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/tags?post=5834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}