You have determined that waiting times at a toll booth are uniformly distributed over the interval 20 to 60 seconds. What formula would you use in Excel to generate random values in this range that follow the uniform distribution?
A) = (60 − 20) × RAND()
B) = (60 + 20) × RAND()
C) = 20 + (60 − 20) × RAND()
D) = 60 + (60 − 20) × RAND()
E) = 20 + (60 + 20) × RAND()

Question

Quizplus · Accepted Answer

To generate random values that follow a uniform distribution over the interval 20 to 60, we need to add the lower bound (20) to the product of the range (60-20) and the Excel RAND() function, which generates a random number between 0 and 1. Therefore, C is the correct formula, giving a range of values between 20 and 60 seconds.

You Have Determined That Waiting Times at a Toll Booth