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

Question

Quizplus · Accepted Answer

To generate random values in a uniform distribution in Excel, we need to use the formula =a + (b-a) * RAND(), where a is the lower limit and b is the upper limit. In this case, a=5 and b=12, so the correct formula is =5 + (12-5) * RAND(), which simplifies to =5 + 7 * RAND(). The only option that matches this formula is E.

You Have Determined That Waiting Times at a Restaurant Are