Abstract:

Orthogonal experiment is an one of important analytical methods of dispensing optimization of pharmaceuticals. This paper introduces how to establish the procedure for statistical analysis on dispensing optimization of pharmaceuticals with Visual Basic, and then it illustrates the usage and skill with an example. The results show that the procedure will calculate visual analysis , analysis of variance and the optimum extraction according to the R value quickly and accurately after the user inputs raw data of test. Compared with special statistics analysis software DPS, the result of regression analysis turns out to be matched, what’s more, this procure is quick, convenient, and easy to operate with the result being highly accurate. Therefore, it can strongly improve the efficiency dispensing optimization of pharmaceuticals.