The following table shows the probability of demand for automobiles used in an Excel simulation. The "= RAND()" function results in a random number for week #1 of 0.2239.The "= VLOOKUP" function is used with the table above to generate a random car demand for week #1.The resulting random car demand for this week is:
A)1 car.
B)2 cars.
C)3 cars.
D)4 cars.

Question

The following table shows the probability of demand for automobiles used in an Excel simulation.  The "= RAND()" function results in a random number for week #1 of 0.2239.The "= VLOOKUP" function is used with the table above to generate a random car demand for week #1.The resulting random car demand for this week is:
A)1 car. 
B)2 cars. 
C)3 cars. 
D)4 cars.

Quizplus · Accepted Answer

In the table, the probability for 2 cars demand in week #1 is 0.2026, which is the closest probability to the generated random number of 0.2239. Therefore, the resulting random car demand for week #1 is 2 cars.

The Following Table Shows the Probability of Demand for Automobiles