Randomization For Clinical Trials in Microsoft Excel: Video Tutorial

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’s to do the work.

  1. I have created a Microsoft Excel sheet which I will use for this demo.
  2. Now, in 1st column, I will write Volunteer/ Patient numbers. In this demo, I am taking 20 patients/ volunteers.
  3. In 2nd 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.
  4. I am giving 1st 10 samples as placebo and next 10 as Test group.
  5. In 3rd column, I will be adding randomization Formula, which is between 0-1.
  6. Insert a function called “RAND” in the 1st row of 3rd
  7. Excel has added a random number to the cell.
  8. Now I will add random numbers in an entire column.
  9. As you can see, all the calls in 3rd column are now random numbers.
  10. Now I will filter column 2 and column 3 as we want to randomise column 2.
  11. Now you can see, top row header has a filter option.
  12. Now I will filter column 3 content as ascending or descending to randomize it.
  13. Now you can see that all the content in column 2 is now randomized.
  14. Now all the volunteer/ patient numbers are randomized to either test or Placebo groups.
  15. Thank you for watching this video.

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/3rd of the sample has to be given any of the group names and then randomized.


No comments!

There are no comments yet, but you can be first to comment this article.

Leave reply

Only registered users can comment.

Skip to toolbar