{"id":5825,"date":"2016-07-09T23:08:26","date_gmt":"2016-07-09T17:38:26","guid":{"rendered":"https:\/\/medicosplexus.com\/?p=5825"},"modified":"2016-07-09T23:08:26","modified_gmt":"2016-07-09T17:38:26","slug":"randomization-clinical-trials-microsoft-excel-video-tutorial","status":"publish","type":"post","link":"https:\/\/medicosplexus.com\/randomization-clinical-trials-microsoft-excel-video-tutorial\/","title":{"rendered":"Randomization For Clinical Trials in Microsoft Excel: Video Tutorial"},"content":{"rendered":"<p><iframe loading=\"lazy\" title=\"Randomization in Microsoft Excel Sheet\" width=\"1020\" height=\"574\" src=\"https:\/\/www.youtube.com\/embed\/1M4EmOBLVKQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p>In this video tutorial, I will show all of you how to do randomization of samples by Random Allocation method while doing a clinical study\/ clinical trial. I will do this in Microsoft Excel Sheet so that researchers will not need any randomization software\u2019s to do the work.<\/p>\n<ol>\n<li>I have created a Microsoft Excel sheet which I will use for this demo.<\/li>\n<li>Now, in 1<sup>st<\/sup> column, I will write Volunteer\/ Patient numbers. In this demo, I am taking 20 patients\/ volunteers.<\/li>\n<li>In 2<sup>nd<\/sup> column, I will write the groups in which I am putting those samples. In my case either it is a Test group or a placebo group.<\/li>\n<li>I am giving 1<sup>st<\/sup> 10 samples as placebo and next 10 as Test group.<\/li>\n<li>In 3<sup>rd<\/sup> column, I will be adding randomization Formula, which is between 0-1.<\/li>\n<li>Insert a function called \u201cRAND\u201d in the 1<sup>st<\/sup> row of 3<sup>rd<\/sup><\/li>\n<li>Excel has added a random number to the cell.<\/li>\n<li>Now I will add random numbers in an entire column.<\/li>\n<li>As you can see, all the calls in 3<sup>rd<\/sup> column are now random numbers.<\/li>\n<li>Now I will filter column 2 and column 3 as we want to randomise column 2.<\/li>\n<li>Now you can see, top row header has a filter option.<\/li>\n<li>Now I will filter column 3 content as ascending or descending to randomize it.<\/li>\n<li>Now you can see that all the content in column 2 is now randomized.<\/li>\n<li>Now all the volunteer\/ patient numbers are randomized to either test or Placebo groups.<\/li>\n<li>Thank you for watching this video.<\/li>\n<\/ol>\n<p>In the tutorial, I have only included 2 groups namely Placebo and Test. Students\/ Researchers can include any number of groups they want. This method can be used to randomize patients\/ volunteers in Placebo, Drug, Standard Treatment etc groups. If there are 3 groups then 1\/3<sup>rd<\/sup> of the sample has to be given any of the group names and then randomized.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this video tutorial, I will show all of you how to do randomization of samples by Random Allocation method while doing a clinical study\/ clinical trial. I will do this in Microsoft Excel Sheet so that researchers will not need any randomization software\u2019s to do the work. I have created a Microsoft Excel sheet [&#8230;]\n","protected":false},"author":7,"featured_media":5828,"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,161],"_links":{"self":[{"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/posts\/5825"}],"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=5825"}],"version-history":[{"count":0,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/posts\/5825\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/media\/5828"}],"wp:attachment":[{"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/media?parent=5825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/categories?post=5825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/medicosplexus.com\/wp-json\/wp\/v2\/tags?post=5825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}