效价测定excle计算表格

剂间比：2浓度比：1924.7供试品名称：生产单位：批号：二次曲线检验日期：打印时间：2020/3/290:57碟号dS1dS2dT1dT2∑ym118.9021.0018.9521.0079.85219.2521.1019.2521.2580.85318.6021.0518.8520.6079.10418.9020.5518.7021.0079.15518.9520.9518.8021.1079.80618.5521.3018.9520.9079.70718.6020.8519.0520.6079.10818.8520.8519.1020.7579.55919.1521.3519.3521.3081.151018.6020.7018.7520.8578.90∑yk188.35209.70189.75209.35797.15供试品间F1=0.98P=0.05F=4.21P0.05不显著(V)回归F2=1493.90P=0.01F=7.68P0.01非常显著(V)偏离平行F3=2.73P=0.05F=4.21P0.05不显著(V)剂间F4=499.20P=0.01F=4.60P0.01非常显著(V)碟间F5=5.09P=0.01F=3.15P0.01非常显著(×)FALSE碟数m=10圈数K=4估计效价At=924.7剂间比r=2浓度比D=1对数值I=0.3010t值（P=0.95)t=2.052样品平方差S2=0.0281自由度f=27.0R/D的对数M=0.0077回归系数S=0.0028标准误差Sm=0.0078对数比值R=1.018R上线Rh=1.056R下限R1=0.9811测定效价Pt=941.28Pt上限Ph=976.67下限P1=907.26可靠性检测结果：实验设计方法：量反应平行线测定随机区组设计（K，K）法——管碟琼脂扩散法估计效价(At):平均可信限率Pt的FL%=3.687%回归非常显著,偏离平行不显著,实验成立