Question

need help 1.

1. Rewrite the left side of each equation as a limit. Simplify the expressions so that all terms on the right are functions of the t and terms on the left are functions of (t+∆t).

(dont know how to rearrange) i have provided my data if its needed (see image atrached)

Note- this is done with the SIR MODEL

2 b Label the first 4 columns: Time (t), Susceptible, Infected, Recovered. Move over about 5 columns and label the column 'Constant Values' then in each cell of that column define the constants from the equations above and give them appropriate values based on your data. (Look up how to define constants in Excel)

2 c Using the equations from (part b) create a formula to calculate each quantity at the current time-step in the first cell under the column heading. Once you are satisfied that you have entered the correct formula, copy and paste the formula from the cell you entered it in, down the column for 45 steps.

very lost with what to do

any help of insight would be very appreciated. thank you

Modeling with Sir: Go to the Reading Materials folder and watch the SIR Model video and take notes. This video explains the mathematical model for the spread of disease within a population. The equat in the SIR model should look familiar, dl dR = - GSI. =asi-bl, or dt dt dr 1. Rewrite the left side of each equation as a limit. Simplify the expressions so that all terms on the right are functions of the t and terms on the left are functions of (t+A1. 2. Excel simulation steps a. Add another sheet to your Excel datasheet and rename it Simulation in the tab at the bottom of the sheet. b. Label the first 4 columns: Time (1. Susceptible, infected, Recovered. Move over about 5 columns and label the column Constant Values' then in each cell of that column define the constants from the equations above and give them appropriate values based on your data. (Look up how to define constants in Excel c. Using the equations from (part b) create a formula to calculate each quantity at the current time-step in the first cell under the column heading. Once you are satisfied that you have entered the correct formula, copy and paste the formula from the cell you entered it in, down the column for 45 steps. 3. Output: Plot all quantities (s. 1, R) on the same graph. Move the graph to a new sheet and label the sheet SIR -STATE (e.g.SIR-GA) Congratulations you just coded your own SIR modell

Answer 1

ANSWER:

1)

At A & tot at * asi By definition of derivative as st+ot) -54t) = lim at Ato AlQ lim strat) - sit) Atso t lim stt+1+) lim 51 =-asi Atto at lim s(t tat) At> 0 At Atto at asi ling so At o at casi- at 13 di म Erl sto dR at ato RI -asi-bi > lim (t+ At) – 1 (t) Ato I lim Ittat 4t = by 1(t) 440 AT .asi-bl RI - lim R(t+at) -R(A) dt a lim R(t+at) lim RCD Ato at At at I lim Rt+4) lim tru ato 440 At = RU - At