利用Excel表格建立药物生物等效性自动数据处理系统

目的:基于Excel建立一种简便的药物生物等效性检验的方法。方法:利用Excel统计函数,进行方差分析、双单侧t检验和90%置信区间等统计学检验。结果:基于Excel可进行药物生物等效性检验,结果与《生物药剂学与药物动力学》一致,而且由于Excel具有重复计算功能,再次检验时,替换其中数据即可快速得到3种检验结果。结论:Excel统计函数可用于药物生物等效性检验计算。

Establishing Automatic Data Processing System for Drug Bioequivalence Using Excel Sheet

OBJECTIVE： To establish a simple method for drug bioequivalence test based on Excel function. METHODS： The statistical tests including ANOVA, two one - side test and 90% confidence interval were carried out using Excel statistical function. RESULTS： Drug bioequivalence test can be performed based on Excel, with results in line with those stated in Biopharmaceutical and Pharmacokinetic. Moreover, due to Excel＇s repeated calculation function, for retest, three kinds of test results were available rapidly only by replacing the data with others remained for calculation. CONCLUSION： Excel function can be used to calculate drug bioequivalence.