2007. 9. 29 Excel- 2 1 2 n i a i a 2S S = P (x i Äa) 2 a S 2 3 S = 8a 2 Ä 96a + 380 = 8(aÄ6) 2 +92 = n(aäx) 2 + S; se = p V =n 4 S V se se S+V S+FV F = F(1; nä 1; 0:05) =t(nä 1;0:05) 2 2 2 2 2 2 aa, b nx nx S = (y iäby i) 2 = (y iä (a+ bx i)) 2 i=1 i=1 5 6
7 8 S a, b 9, 10 ExcelLINEST a,b LINEST b 0.241 b 2 2 260 11 12
b q q V se(by) = e 60 = 14:643=6 60 = 0:201 LINEST 0.241 b a =4 b b a 13 14 S S 2 2 42 q q Ve se(by) = = 14:643=6 = 0:241 42 42 LINEST 15 16 b Se+ Ve=14.643+2.440=17.083 Se+F Ve= 14.643+5.987*2.441 =29.25 a,b S S 17 18
y=8 x 8 y=8 x 8 =(8-a)/b=(8-3.96)/1.36=2.974 y = a + bx (1) y = 8 + b(xä x8) (2) x 8 Excel 19 20 x 8 x 8 Se=29.25 1.964.68 y=8 y-hat x8 S+V 2 21 22 23 y =a +bx (1) y = 8 + b(xä x8) = 8 + bxä bx8(2) a, b 1 bx 8 24
x y y = ab x ; log(y) = log(a) + log(b)x = ax b ; log(y) = log(a) +alog(x) 25 26 ab x ax b log(y) log(x) log(y) a,b 27 +c ab x b<1 y = y 1 + (y 0 Ä y 1 )b x = y1 + (y0ä y1)exp(bx) 28 y 2 29 30
Box-Cox p y* y* p p=0.135 0.9999 0.135 y É = yp Ä 1 p 31 ( T y = A exp Ä Å ÄE RT 32 x0 y0 bl br x0 1000/3.6045 =277K 33 S ( ( 34 y maxäy min y = y min + 1 + exp(ä(a + bx)) max y min y = = y max 1 + exp(ä(a + bx)) y max 1 + exp(äb(xäx 50 )) x= 50 =2 y=y max /2 a (1) (2) 35 Emax y = EmaxÅxç x ç +EC ç 50 y = = E max 1 + ECç 50 x ç E max 1 +exp(ç(ln(ec 50)Äln(x))) 36
Emax Michaelis-Menten x 0.125 2 Michaelis-Menten b=1 y max y = 1 + exp(äb(ln(x)äln(x 50))) x ln(x) log(x) 37 38 y-hat=ymax/(1+exp(-b*(ln(x)-ln(x50)))) B A Bx A y A = f (x) = g(ln(x)) y B = f (cçx) = g(ln(c) + ln(x)) x x 39 40 Emax c=2 A 0.192, 0.48, 1.2, 3 4 y B A A2 0.384, 0.98, 2.4, 6 4 ymin ymax bd50 c 41 42
y maxäy min by A = y min + 1 + exp(äb(ln(x)ä ln(x 50 )) by B = y maxäy min y min + 1 + exp(äb(ln(cx)äln(x 50 )) 43 AB A,B5,7 115+7=12 44 A=4 B=2 (18+20)/2=19 22 A=6, B=3 (19+22)/2=20.5 25, 25 45 A,B A B d x A B dx A B 46 0, 1, 2, 3, 4, 5 47 48
Excel y =y inf Ä (y inf Äy 0 ) exp(bx) 4312 2 2 2 49 x=0 y 0 y 0 y 0 2 50 3 0.018720.01835=0.00037 4y inf B R2=0.9191 51 y inf B 4 52 t=0 x x 0 dy dx = (y0ä y1)bebx ) (y 0Ä y 1)B (x = 0) c B c B = y 0 Äy 1 53 B y 0 y inf Se 0.02047 y 0 0.01872 3 0.0175 0:00175=3 F = 0:01872=(24Ä9) ô 0:6 54
2 55 2 56 1<p<2) p. 57 58 2 Gauss-Newton 59 60
2 2 2 0.2 n=10 f=3 2 0 10 =0.2 61 62 =0.2 f=3 0.20 =0.50.12 0.3 63 64 n=10 p=f/n 65 p-hat=1/(1+exp(-(a+b*ln(x)))) -2ln(L)=-2*LN(BINOMDIST(f, n,p-hat,false)) p-hat=1/(1+exp(-b*(ln(x)-ln(x50)))) 66
2 p-hat 1 bp = 1 + exp(ä(a + bln(x))) 1 bp = 1 + exp(äb(ln(x)äln(x 50)) 2-2ln(L)) 2 Excel =BINOMDIST(f, n,, FALSE) p-hat -2ln(L) L L p=f/n z=ln(p/(1-p)) a+bx 2 z=b(x-x 50 ) 67 68 20% 2 0.2 ~ 1.0 100% 0 Excel VBA 2 2 69 70 71 R, S Excel 72