药物有效期计算公式(24个月).xlsVIP

程序 斜率b= 截距a= 相关系数r= 时间(月)X 实测值(%)Y 标示量% 上界值% 下界值 % 含量低限% 有效期 Z值% .00 99.30 100.87 1.23 .05 2.00 4.00 1.00 8.00 2.00 102.10 99.65 95.00 28.85 -.24 -.24 2.00 4.00 -1.80E-03 98.41 90.00 2.00 -1.80E-03 3.00 101.10 99.82 1.05 .05 2.00 4.00 1.00 8.00 2.00 100.88 98.77 95.00 6.00 99.50 98.77 .91 .05 2.00 4.00 1.00 8.00 2.00 99.68 97.87 95.00 9.00 98.40 -.35 97.72 .80 .05 2.00 4.00 1.00 8.00 2.00 98.52 96.92 95.00 12.00 96.00 100.87 96.67 .75 .05 2.00 4.00 1.00 8.00 2.00 97.42 95.93 95.00 18.00 94.00 -.97 94.58 .85 .05 2.00 4.00 1.00 8.00 2.00 95.42 93.73 95.00 24.00 92.50 92.48 1.14 .05 2.00 4.00 1.0