
126 Practical Spreadsheet Risk Modeling for Management
b. One disadvantage of tables like this is that only discrete steps of
information are given. For example, there have been proposals to
cap individual Internet usage at 5 GB per month; usage levels above
this would entail surcharges. Table4.1 does not readily show what
percentage of users would be impacted by such a cap. Use your
Lognormal distribution from part (a) to estimate this percentage.
c. Assume that annual growth in each of the next 3 years will follow
a Uniform distribution with a minimum of 30% and a maximum of
35%. Simulate 3 years of growth in broadband usage levels. ...