运用EXCEL函数进行完全随机试验设计

Completely Randomized Design by EXCEL Function

完全随机设计的实质是将供试单位随机分组该文通过对完全随机设计实质的分析，对运用EXCEL进行完全随机试验设计的方法进行了介绍。结果认为只要每一独立供试单位在组间随机排列，始终贯穿随机精神以最大限度地减少系统误差，灵活利用Excel的随机函数如RANDOM、RANDOMBETWEEN等和排序按钮，用任何一种方法都可以快速的进行完全随机试验设计。

Completely randomized design is one of the standard recommendations in experimental design, by which the experimental units be randomly allocated to treatment groups. This ensures that systematic differences between experimental units that might confound our interpretation of treatment effects are minimized. In this article, how to allocate the experimental units by Completely randomized design with EXCEL function is introduced. Finally, we thinks that, as long as the experimental units be randomly arranged in groups, and the completely random spirit were run through experimental design to minimize system error, the random function such as RANDOM,RANDOMBETWEEN etc. in Excel can be used to do the completely randomized design rapidly.