In this study, patients are assigned to treatment groups using a stratified block randomization (block size 8) method using Microsoft Excel software. Treatment groups are first identified in blocks of 8, and then a random number is generated for each patient using the RAND() function. These random values are used to randomly sort the blocks. Patients are assigned sequentially from the randomized list in the order of enrollment to maintain a balance in the number of patients in each group. Treatment groups include UDCA + atorvastatin, UDCA alone, atorvastatin alone, and placebo.
Technically, patient allocation is performed at the time of enrollment using the INDEX() function, which assigns a treatment group to a new patient from the randomized list. This method ensures that patients are distributed fairly and without bias to the treatment groups. The study is designed as a triple-blind design, meaning that the patient, the evaluating physician, and the data analyst are unaware of the assigned treatment group. This method in Excel allows for simple and reproducible randomization without the need for complex statistical software.
In Excel, randomization is performed by combining the RAND(), SORT(), and INDEX() functions. First, RAND() generates a random number between 0 and 1 for each patient. Then, using the Sort function based on the RAND() values, the order of the patients is randomly changed. After sorting, the INDEX() function is used to assign new patients to one of the treatment groups in the order they arrive. This method is considered a practical and reliable solution for randomization in clinical studies due to its simplicity, high accuracy, and control of balance between groups.