Prerequisite: Slides 2.87-2.89
(1) Implement the data-based tank vs AT model shown on slide 2.89 using the Ph probabilities shown on slide 2.89. Keep in mind that the M3s move at a constate speed of 8 mps, so only one column of the table is needed. You can implement that column using nested Excel IF functions.
Given a hit, the Pk is always 0.8, regardless of range. The AT gun does not fire at time 0.
(2) Run the model 30 times (by repeatedly pressing the F9 key). Manually count how many times at least one tank survives to destroy the AT gun.