冰山
第17楼2015/11/01
excel中没有“非线性”选项,二次,三次等倒是有,可毕竟不一样。非线性的公式不是普通的二次方程。
附:非线性公式:
C=K0*(K1*A+K3*A*A)/(K2*A-1)
C:浓度
A:吸光度
K0,K1,K2,K3 :斜率和各种常数,见原文(In this expression, C is the concentration, A is the observed absorbance or emission, K1, K2, and K3 are coefficients determined during the calibration procedure, and K0 is the reslope coefficient that is set equal to 1.0 during the initial calibration. When the number of calibration standards used exceeds the number of coefficients, the method of least squares is used to determine the coefficients.)