Final Exam
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt Play1/57
There's no tags or description
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
58 Terms
A normally distributed random variable with a mean of 10 and a standard deviation of 10 can be generated in Excel using the formula ...
=NORMINV(RAND(),10,10)
A normally distributed random variable with a mean of 20 and a standard deviation of 20 can be generated in Excel using the formula ...
none of the other answers.
A random number with uniformly distributed integer values from 5 to 10, including both 5 and 10, can be generated with the Excel formula …
=5 + RANDBETWEEN(0,5)
The only way to increase the statistical certainty of the output of a simulation model is ...
to take a larger sample size.
Some formulas for a newsboy simulation are shown below. The number of incorrect formulas shown is ...
2
In order to generate random values from the table of discrete values shown below, the cum.prob. column should have values ...
0.00, 0.25, 0.35, 0.65
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 ...
150
A random number with uniformly distributed integer values from 10 to 100, including both 10 and 100, can be generated in Excel using ...
=RANDBETWEEN(10,100)
A random number uniformly distributed between the -5 and +10.5 can be generated with the Excel formula ...
= -5 + 15.5*RAND()
The completed yield management problem had a solution of approximately ...
price more than $100 for more than 110 contracts.
If a number is generated from the discrete table of values shown below using the function =VLOOKUP(0.85,Table,2), then the function will return the value ...
some other number.
A random number with uniformly distributed integer values from 1 to 10, including both 1 and 10, can be generated in Excel using ...
=INT(1+10*RAND())
A random number uniformly distributed between 10 and 100 can be generated with the Excel formula ...
=90*RAND()+10
A random replication of an Excel simulation model constructed on a single line can be effected by ...
appropriate copy-and-paste of the line.
On general observation of the newsboy problem is that ...
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.65,Table,2), then the function will return the value ...
200
Suppose that demand in the newsboy simulation shown below is 225, the associated profit is ...
Between $100 and $500, but not $100 nor $500.
In order to decrease the uncertainty in a mean value estimate by a factor of two requires _____ times as many observations.
four
Suppose that full-price demand and half price demand are as shown below, resulting profit is ...
Between $100 and $500, but not $100 nor $500.
If a number is generated from the discrete table of values shown below using the function =VLOOKUP(0.55,Table,2), then the function will return the value ...
some other number
A random number with uniformly distributed integer values from 0 to 10, including both 0 and 10, can be generated in Excel using ...
=RANDBETWEEN(0,10)
Increasing the number of observations by a factor of ten will decrease by a factor of ____ the uncertainty in a mean value estimate.
three
In order to generate random values from the table of discrete values shown below, the cum prob column should have values ...
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 ...
=5.5*RAND()+5
The base function to generate random numbers in Excel is ...
RAND()
The twin problems of a classic newsboy problem are ...
ordering too few and ordering too many.
If a number is generated from the discrete table of values shown below using the function =VLOOKUP(0.45,Table,2), then the function will return the value ...
150
A normally distributed random variable with a mean of 20 and a standard deviation of 10 can be generated in Excel using the formula ...
=NORMINV(RAND(),20,10)
In using a data table to construct a simulation, the random replications of the simulation in the following dialog box are generally associated with ...
a blank cell referred in the Column input cell.
A normally distributed random variable with a mean of 20 and a standard deviation of 10 can be generated in Excel using the formula ...
=NORMINV(RAND(),20,10)
A random number uniformly distributed between 0 and 2 can be generated with the Excel formula ...
=2*RAND()
A random replication of an Excel simulation model can be effected by ...
using the F9-recalculation key.
General observations from the yield management simulation are ...
that contracts for some perishable goods are systematically oversold relative to available supply.
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 ...
20
A random number with uniformly distributed integer values from 0 to 10, including both 0 and 10, can be generated in Excel using ...
=INT(11*RAND())
Increasing the number of observations by a factor of two will decrease by a factor of ____ the uncertainty in a mean value estimate.
less than 1.5
A normally distributed random variable with a mean of 100 and a standard deviation of 100 can be generated in Excel using the formula ...
none of the other answers.
In order to decrease the uncertainty in a mean value estimate by a factor of two requires _____ times as many observations.
four
In order to decrease the uncertainty in a mean value estimate by a factor of ten requires _____ times as many observations.
more than 100
A random number uniformly distributed between 1 and 2 can be generated with the Excel formula ...
=1+RAND()
In order to decrease the uncertainty in a mean value estimate by a factor of four requires _____ times as many observations.
more than 10
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 ...
some other number.
A random number uniformly distributed between 1 and 2 can be generated with the Excel formula ...
=1+RAND()
In order to decrease the uncertainty in a mean value estimate by a factor of two requires _____ times as many observations.
four
One general observation of the newsboy problem is that ...
if overstock costs are higher than understock costs, then less units than expected demand should be ordered.
In order to decrease the uncertainty in a mean value estimate by a factor of two requires _____ times as many observations.
four
A random number uniformly distributed between 1 and 10 can be generated with the Excel formula ...
=1+9*RAND()
A random number uniformly distributed between 0 and 2 can be generated with the Excel formula ...
=2*RAND()
A random replication of an Excel simulation model can be effected by ...
using the F9-recalculation key.
A random number uniformly distributed between 1 and 2 can be generated with the Excel formula ...
=1+RAND()
A random number uniformly distributed between 0 and 2 can be generated with the Excel formula ...
=2*RAND()
In order to decrease the uncertainty in a mean value estimate by a factor of four requires _____ times as many observations.
more than 10
The base function to generate random numbers in Excel is ...
RAND()
A normally distributed random variable with a mean of 100 and a standard deviation of 10 can be generated in Excel using the formula ...
=NORMINV(RAND(),100,10)
A random number uniformly distributed between 0 and 10 can be generated with the Excel formula ...
=10*RAND()
In order to decrease the uncertainty in a mean value estimate by a factor of ten requires _____ times as many observations.
more than 100
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 ...
150
Random replications of an Excel simulation model can be captured by ...
appropriate use of a data table.