$2-21$ Use a spreadsheet program $($such as QuattroPro, Lotus, Excel$)$ to solve Problem $2-4.$ Break the distance from $10ft$ to $500ft$ into several intervals. Use a small enough distance increment so that the results are essentially independent of the increment size. Your spreadsheet output should have designated columns for the distance, pressure, probit values, percentages, and the number of individuals affected for each increment. You should also have two spreadsheet cells that provide the total number of individuals with eardrum ruptures and lung hemorrhage deaths. For converting from probits to percentages, use a lookup function or an equivalent function.

$2-4$ The peak overpressure expected as a result of the explosion of a tank in a plant facility is approximated by the equation

$logP=4\mathrm{.}2-1\mathrm{.}8logr$

where $P$ is the overpressure in psi and $r$ is the distance from the blast in feet. The plant em$-$ ploys $500$ people who work in an area from $10$ to $500ft$ from the potential blast site. Estimate the number of fatalities expected as a result of lung hemorrhage and the number of eardrums ruptured as a result of this blast. Be sure to state any additional assumptions.