Two Stage Model Spreadsheet
no subj dose(mouse) dose(human) no. wi tumor prop pi log likelihood
50 0 0.001 0 0 8.5E-09 -4.25E-07
50 25 3.5714 4 0.08 0.0912333 -13.978017
50 50 7.1429 20 0.4 0.3179554 -34.39669
50 100 14.286 37 0.74 0.7836 -28.920841
          Sum -77.295548
q1= 0.000001 q2 = 0.0075      
             
TWO STAGE MODEL            
  Formulas          
  dose(human) = dose(mouse)/7          
  Fi= pi=1-Exp(-q1*dose-q2*dose^2) = 1-Exp(-$B$7*Ci-$D$7*Ci^2)          
  log likelihood = Di*LN(Fi)+(50-Di)*LN(1-Fi)          
  G6 = Sum(G3:G5)          
  Seed q1 = .001 q2 = .01          
  Try to use Solver to maximize G6 by changing B7 and D7          
  No luck, even using various seeds.          
  Try various possibilities, to estimate q1 = 0.000001,q2 = 0.0075          

Last Updated on 11/16/01
By Martha Smith