Filters
Question type

Study Flashcards

The __________ function is used to generate a pseudorandom number in Excel.


A) FREQUENCY()
B) RAND()
C) NORM.INV()
D) ROUND()

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

All the values of computer-generated random numbers are


A) Poisson distributed.
B) lognormally distributed.
C) uniformly distributed.
D) normally distributed.

E) A) and C)
F) None of the above

Correct Answer

verifed

verified

The values for random variables in a Monte Carlo simulation are


A) selected manually.
B) generated randomly from probability distributions.
C) taken from forecasting analysis.
D) derived secondarily using formulas.

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

The choice of the probability distribution for a random variable can be guided by


A) an objective function.
B) likelihood factors.
C) forecasting.
D) historical data.

E) B) and C)
F) C) and D)

Correct Answer

verifed

verified

Which of the following cannot be described by a discrete probability distribution?


A) Sales of two medical devices in which Device A generates $35 per unit sold and will likely constitute 30% of the sales and Device B generates $50 per unit sold and will likely constitute 70% of the sales.
B) The labor cost for manufacturing goods, where one-third of the units cost $10 in labor, one-third cost $15 in labor, and one-third cost $50 in labor.
C) The cost of parts for manufacturing an item, where the parts can take on any value between $80 and $100.
D) The number of units produced in a given day, where 20% of the time 99 units are produced and 80% of the time 100 units are produced.

E) C) and D)
F) A) and C)

Correct Answer

verifed

verified

Which of the following parameters is required to convert a computer-generated random variable into a uniform random variable?


A) Range of the distribution
B) Mean of the distribution
C) Variance of the distribution
D) Moments of the distribution

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

The range of computer-generated random numbers is


A) [-8, 8].
B) [-8, 0) .
C) [1, 8].
D) [0, 1) .

E) None of the above
F) A) and C)

Correct Answer

verifed

verified

A disadvantage of the simple what-if analyses is that


A) there are errors induced as a result of rounding.
B) the optimal solutions are not guaranteed.
C) there is no indication of the likelihood of various output values.
D) it cannot compute alternate optimal solutions.

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

The process of evaluating a decision in the face of uncertainty by quantifying the likelihood and magnitude of an undesirable outcome is known as


A) risk analysis.
B) regression analysis.
C) data mining.
D) decision tree analysis.

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

The process of determining that a computer program implements a simulation model as it is intended is known as


A) validation.
B) verification.
C) correlation.
D) optimization.

E) C) and D)
F) A) and B)

Correct Answer

verifed

verified

Which of the following functions computes a value such that 2.5% of the area under the standard normal distribution lies in the upper tail defined by this value?


A) =NORM.S.INV(0.975)
B) =NORM.S.INV(0.025)
C) =NORM.S.INV(0.05)
D) =NORM.S.INV(0.95)

E) B) and C)
F) B) and D)

Correct Answer

verifed

verified

In a base-case scenario, the output is determined by assuming


A) worst values that can be expected for the random variables of a model.
B) the mean trial values for the random variables of a model.
C) best values that can be expected for the random variables of a model.
D) the most likely values for the random variables of a model.

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

The __________ function in Excel is used to compute the statistics required to create a histogram.


A) NORM.INV
B) RAND
C) FREQUENCY
D) STDEV.S

E) None of the above
F) All of the above

Correct Answer

verifed

verified

A description of the range and relative likelihood of possible values of an uncertain variable is known as a


A) risk analysis.
B) probability distribution.
C) base-case scenario.
D) simulation optimization.

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

Which of the following cannot be modeled by a continuous distribution?


A) Length of time it takes to manufacture a product
B) Height of the finished manufactured product
C) Weight of a finished manufactured product
D) Number of products produced in an hour

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

A(n) __________ is an input to a simulation model whose value is uncertain and described by a probability distribution.


A) identifier
B) constraint
C) random variable
D) decision variable

E) All of the above
F) C) and D)

Correct Answer

verifed

verified

Which of the following numbers cannot result from the Excel function =NORM.INV(RAND( ) , 100, 10) ?


A) 99
B) 115
C) 121
D) All of these numbers can result from this Excel function.

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

A simulation model extends spreadsheet modeling by


A) extending the range of parameters for which solutions are computed.
B) using real-time values for parameters from the application to formulate solutions.
C) replacing the use of single values for parameters with a range of possible values.
D) using historical data to make predictions about future values and expected trends.

E) C) and D)
F) A) and C)

Correct Answer

verifed

verified

The outcome of a simulation experiment is a(n)


A) objective function.
B) probability distribution for one or more output measures.
C) single number.
D) what-if scenario.

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

A ___________ uses repeated random sampling to represent uncertainty in a model representing a real system and that computes the values of model outputs.


A) Monte Carlo simulation
B) what-if analysis
C) deterministic model
D) discrete event simulation

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

Showing 21 - 40 of 41

Related Exams

Show Answer