To further refine the assumptions of the Olympic bid proposal discussed in Example 12.8, based on additional research, analysts created the following distribution for TV broadcast revenues, which were assumed to be uniform over various intervals, each with a discrete probability (all in millions of dollars):

Develop a spreadsheet to generate ten random variates from this distribution.

Data from Example 12.8

In 1990, Cincinnati was one of six cities in the United States that submitted a proposal to host the 2012 Olympics. The author was involved in assisting the committee to conduct a risk analysis of their budget to predict whether the budget would be met (a condition required by the U.S. Olympic Committee). Because of the uncertainty in estimating many of the financial parameters, such as TV broadcast revenues, ticket sales, and so on, triangular distributions were used to model these uncertainties. Figure 12.9 shows a spreadsheet (Excel file Triangular Random Variates) with the parameters used for estimating broadcast revenues. Formula (12.4) was used to generate the random variate in cell B10. The spreadsheet also shows a table with 100 samples from the distribution. The histogram shows that the distribution is roughly triangular; however, with only 100 samples, there will be considerable variation in the outcomes as the spreadsheet is recalculated. 

Transcribed Image Text:

a $735 $887 $930 $1040 $1087 $1170 b $887 $930 $1040 $1087 $1170 $1300 Probability 0.1 0.15 0.25 0.25 0.15 0.1