My numbers are in the top image. I understand how to get n and r'. What I do not understand is how to get r after t=0. The first r value was given to me, and as you can see it says to use a recursive formula to fill in the rest of column B. I do not know this recursive formula. Can anyone help me to figure out that formula? We will know it's right if I can plug it in and get the value shown in the second image.
B D 1 t r n r' 0 1 0.09 W N 0.5 0 0.400 0.629 0.720 0.720 4 1 0 1.5 0 5 6 2 0.691 0 7 You'll start by determining approximately how many weeks the patient has until the tumor metastasizes, assuming no treatment is given. Open an Excel spreadsheet and rename Sheet1 as no treatment. Label columns A through D in row 1 with t,r, n,r'. Use the initial condition r(0) = 1 centimeter to enter values into cells A2 and B2. Next, type your formulas for n and r' into Excel in cells C2 and D2. Be sure to try them on your own first. Be careful with the parentheses! If you need help, the formulas are included below. (10 - 25).7880= adAt za 120 UI (go+G+I+tv TV)/V):80= zd*z 120 UI Assuming that At = 0.5, fill in the recursive formulas for t and r into cells A3 and B3, respectively. After you have dragged down your formulas to row 6 you should see the following results for the first two weeks. D 1t ON UN B r n 0 1 0.5 0.045 1 0.00012295 1.5 1.0732E-09 2 8.1778E-20 0.400 0.09 0.707 0.00546429 0.810 1.7458E-OS 0.810 1.524E-10 0.777 1.1077E-20 B D 1 t r n r' 0 1 0.09 W N 0.5 0 0.400 0.629 0.720 0.720 4 1 0 1.5 0 5 6 2 0.691 0 7 You'll start by determining approximately how many weeks the patient has until the tumor metastasizes, assuming no treatment is given. Open an Excel spreadsheet and rename Sheet1 as no treatment. Label columns A through D in row 1 with t,r, n,r'. Use the initial condition r(0) = 1 centimeter to enter values into cells A2 and B2. Next, type your formulas for n and r' into Excel in cells C2 and D2. Be sure to try them on your own first. Be careful with the parentheses! If you need help, the formulas are included below. (10 - 25).7880= adAt za 120 UI (go+G+I+tv TV)/V):80= zd*z 120 UI Assuming that At = 0.5, fill in the recursive formulas for t and r into cells A3 and B3, respectively. After you have dragged down your formulas to row 6 you should see the following results for the first two weeks. D 1t ON UN B r n 0 1 0.5 0.045 1 0.00012295 1.5 1.0732E-09 2 8.1778E-20 0.400 0.09 0.707 0.00546429 0.810 1.7458E-OS 0.810 1.524E-10 0.777 1.1077E-20
