12. To further refine the assumptions of the Olympic bid proposal discussed in Example 12.8, based on additional research, analysts created the follow- ing distribution for TV broadcast revenues, which were assumed to be uniform over various intervals, each with a discrete probability (all in millions of dollars): I a b Probability $735 $887 0.1 $887 $930 0.15 $930 $1040 0.25 $1040 $1087 0.25 $1087 $1170 0.15 $1170 $1300 0.1 Develop a spreadsheet to generate ten random variates from this distribution. (Hint: Use Excel lookup functions to choose the distribution param- eters based on the probabilities and then apply the uniform random variate formula.)

12. To further refine the assumptions of the Olympic bid proposal discussed in Example 12.8, based on additional research, analysts created the follow- ing distribution for TV broadcast revenues, which were assumed to be uniform over various intervals, each with a discrete probability (all in millions of dollars): I a b Probability $735 $887 0.1 $887 $930 0.15 $930 $1040 0.25 $1040 $1087 0.25 $1087 $1170 0.15 $1170 $1300 0.1 Develop a spreadsheet to generate ten random variates from this distribution. (Hint: Use Excel lookup functions to choose the distribution param- eters based on the probabilities and then apply the uniform random variate formula.)

Calculus For The Life Sciences

2nd Edition

ISBN:9780321964038

Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.

Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.

Chapter12: Probability

Section12.CR: Chapter 12 Review

Problem 8CR

See similar textbooks