Question: For this project, we will eventually be doing an Euler Method approximation using a horizontal increment of 0 . 0 1 . We will also

For this project, we will eventually be doing an Euler Method approximation using a horizontal increment of 0.01. We will also be assuming that the total population stays constant at 1,000.
Place the horizontal increment in the cell to the right of the cell containing h.
Place the total population in the cell to the right of the cell containing N.
Just for the sake of choosing a starting place, enter a value of 0.005 for the rate of contact and a value of 1 for the removal rate. Plece these values next to the correct labels.
For our initially infected population, let's begin for now with a value of 10.
We will be changing some of the values in later parts of the project to see how changes affect the population. To make this easier and more organized, enter a formula into cell B2 that will auto update your S0, based on what you have entered for I0.
In the section of the video from the 6:25 mark to the 11:00 mark, there is information on how we calculate R0. You will now create a formula in cell B4 to calculate the R0 value, based on what you saw in the video.
At this point, nothing should be entered in your spreadsheet below row 6, but you should have a value or formula next to each of the items in rows 1-4, and (:N}
 For this project, we will eventually be doing an Euler Method

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!