OMGT FINAL TEST QUESTIONS & ANSWERS
A normally distributed random variable with a mean of 10 and a standard deviation of 10
can be generated in Excel using the formula ... - Answer -=NORMINV(RAND(),10,10)
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.35,Table,2), then the function will return the value ... - Answer -
150
A random number uniformly distributed between 1 and 10 can be generated with the
Excel formula ... - Answer -=1+9*RAND()
A random number with uniformly distributed integer values from 0 to 10, including both 0
and 10, can be generated in Excel using ... - Answer -=RANDBETWEEN(0,10)
In order to decrease the uncertainty in a mean value estimate by a factor of ten requires
_____ times as many observations. - Answer -more than 100
Suppose that demand in the newsboy simulation shown below is 225, the associated
profit is ... - Answer -$500 or more.
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.25,Table,2), then the function will return the value ... - Answer -
100
A normally distributed random variable with a mean of 20 and a standard deviation of 10
can be generated in Excel using the formula ... - Answer -=NORMINV(RAND(),20,10)
A random number with uniformly distributed integer values from 0 to 10, including both 0
and 10, can be generated in Excel using ... - Answer -=INT(11*RAND())
A random number with uniformly distributed integer values from 1 to 10, including both 1
and 10, can be generated in Excel using ... - Answer -=RANDBETWEEN(1,10)
Random replications of an Excel simulation model can be captured by ... - Answer -
appropriate use of a data table.
On general observation of the newsboy problem is that ... - Answer -randomness in
amount supplied together with a supplier discount may result in higher order amounts.
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.25,Table,2), then the function will return the value ... - Answer -
100
, In order to generate random values from the table of discrete values shown below, the
cum.prob. column should have values ... - Answer -0.00, 0.25, 0.35, 0.65
In order to generate random values from the table of discrete values shown below, the
cum prob column should have values ... - Answer -0.00, 0.30, 0.50, 0.80, 0.95
A random number uniformly distributed between the values +5 and +10.5 can be
generated with the Excel formula ... - Answer -=5.5*RAND()+5
A random number with uniformly distributed integer values from 0 to 10, including both 0
and 10, can be generated in Excel using ... - Answer -=RANDBETWEEN(0,10)
The base function to generate random numbers in Excel is ... - Answer -RAND()
General observations from the yield management simulation are ... - Answer -that
contracts for some perishable goods are systematically oversold relative to available
supply.
In order to generate random values from the table of discrete values shown below, the
cum prob column should have values ... - Answer -0.00, 0.30, 0.50, 0.80, 0.95
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.75,Table,2), then the function will return the value ... - Answer -
200
A random number with uniformly distributed integer values from 5 to 10, including both 5
and 10, can be generated with the Excel formula ... - Answer -=RANDBETWEEN(5,10)
A random number uniformly distributed between 10 and 100 can be generated with the
Excel formula ... - Answer -=90*RAND()+10
Random replications of an Excel simulation model can be captured by ... - Answer -
appropriate use of a data table.
The twin problems of a classic newsboy problem are ... - Answer -ordering too few and
ordering too many.
In order to generate random values from the table of discrete values shown below, the
cum prob column should have values ... - Answer -0.00, 0.30, 0.50, 0.80, 0.95
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.30,Table,2), then the function will return the value ... - Answer -
20
A random number uniformly distributed between 0 and 2 can be generated with the
Excel formula ... - Answer -=2*RAND()
A normally distributed random variable with a mean of 10 and a standard deviation of 10
can be generated in Excel using the formula ... - Answer -=NORMINV(RAND(),10,10)
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.35,Table,2), then the function will return the value ... - Answer -
150
A random number uniformly distributed between 1 and 10 can be generated with the
Excel formula ... - Answer -=1+9*RAND()
A random number with uniformly distributed integer values from 0 to 10, including both 0
and 10, can be generated in Excel using ... - Answer -=RANDBETWEEN(0,10)
In order to decrease the uncertainty in a mean value estimate by a factor of ten requires
_____ times as many observations. - Answer -more than 100
Suppose that demand in the newsboy simulation shown below is 225, the associated
profit is ... - Answer -$500 or more.
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.25,Table,2), then the function will return the value ... - Answer -
100
A normally distributed random variable with a mean of 20 and a standard deviation of 10
can be generated in Excel using the formula ... - Answer -=NORMINV(RAND(),20,10)
A random number with uniformly distributed integer values from 0 to 10, including both 0
and 10, can be generated in Excel using ... - Answer -=INT(11*RAND())
A random number with uniformly distributed integer values from 1 to 10, including both 1
and 10, can be generated in Excel using ... - Answer -=RANDBETWEEN(1,10)
Random replications of an Excel simulation model can be captured by ... - Answer -
appropriate use of a data table.
On general observation of the newsboy problem is that ... - Answer -randomness in
amount supplied together with a supplier discount may result in higher order amounts.
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.25,Table,2), then the function will return the value ... - Answer -
100
, In order to generate random values from the table of discrete values shown below, the
cum.prob. column should have values ... - Answer -0.00, 0.25, 0.35, 0.65
In order to generate random values from the table of discrete values shown below, the
cum prob column should have values ... - Answer -0.00, 0.30, 0.50, 0.80, 0.95
A random number uniformly distributed between the values +5 and +10.5 can be
generated with the Excel formula ... - Answer -=5.5*RAND()+5
A random number with uniformly distributed integer values from 0 to 10, including both 0
and 10, can be generated in Excel using ... - Answer -=RANDBETWEEN(0,10)
The base function to generate random numbers in Excel is ... - Answer -RAND()
General observations from the yield management simulation are ... - Answer -that
contracts for some perishable goods are systematically oversold relative to available
supply.
In order to generate random values from the table of discrete values shown below, the
cum prob column should have values ... - Answer -0.00, 0.30, 0.50, 0.80, 0.95
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.75,Table,2), then the function will return the value ... - Answer -
200
A random number with uniformly distributed integer values from 5 to 10, including both 5
and 10, can be generated with the Excel formula ... - Answer -=RANDBETWEEN(5,10)
A random number uniformly distributed between 10 and 100 can be generated with the
Excel formula ... - Answer -=90*RAND()+10
Random replications of an Excel simulation model can be captured by ... - Answer -
appropriate use of a data table.
The twin problems of a classic newsboy problem are ... - Answer -ordering too few and
ordering too many.
In order to generate random values from the table of discrete values shown below, the
cum prob column should have values ... - Answer -0.00, 0.30, 0.50, 0.80, 0.95
If a number is generated from the discrete table of values shown below using the
function =VLOOKUP(0.30,Table,2), then the function will return the value ... - Answer -
20
A random number uniformly distributed between 0 and 2 can be generated with the
Excel formula ... - Answer -=2*RAND()
