Question 1

How can random numbers be generated?

Accepted Answer

The answer of How can random numbers be generated?...

Question 2

In Excel,typing the function ________ will generate random numbers within the interval 0 to 1.

Accepted Answer

The answer of In Excel,typing the function ________ will generate...

Question 3

This table shows the distribution of grades in an operations management class.  Add a column to the table that shows the cumulative probability and indicate what letter grade is obtained when the RAND()function is equal to 0.7406
A)A
B)B
C)C
D)D

Accepted Answer

The answer of This table shows the distribution of grades...

Question 4

If the data needed to set up a simulation are available in company records,the technique used to obtain them is called ________.

Accepted Answer

The answer of If the data needed to set up...

Question 5

This table shows the distribution of grades in an operations management class.  Add a column to the table that shows the cumulative probability and indicate what letter grade is obtained when the RAND()function is equal to 0.982245
A)A
B)B
C)C
D)D

Accepted Answer

To calculate the cumulative probability, we need to add up the probabilities of all the grades up to the grade in question.

For example, to calculate the cumulative probability for a grade of B, we would add up the probabilities for grades of A and B: 0.1 + 0.3 = 0.4.

Similarly, the cumulative probability for a grade of C would be 0.4 + 0.25 = 0.65.

And the cumulative probability for a grade of D would be 0.65 + 0.15 = 0.8.

Finally, the cumulative probability for a grade of F would be 0.8 + 0.2 = 1.0.

Therefore, the letter grade obtained when the RAND() function is equal to 0.982245 would be B, as this corresponds to a cumulative probability of 0.4.

Question 6

To generate 100 random numbers in an Excel simulation,the "=RAND()" function is first typed into the A1 cell on an Excel spreadsheet.A1 can then be copied and pasted in a rectangular area on the spreadsheet to cover the cells:
A)A1:E5.
B)A1:H12.
C)A1:J10.
D)A1:E22.

Accepted Answer

The "=RAND()" function can be copied to a total of 100 cells to generate 100 random numbers. Option C, A1:J10, represents a rectangular area of 10 columns by 10 rows, which equals 100 cells.

Question 7

A simulation model is used to test the impact of the number of sample customers at a supermarket.As the model is run,the decision maker watches the average number of customers in the store rapidly increase from zero until it levels off and holds a constant value.The simulation model is:
A)not valid due to the lack of change.
B)in steady state.
C)not valid due to the fluctuation in the statistics.
D)a random variable.

Accepted Answer

The leveling off and holding a constant value indicates that the model has reached steady state, where the system is stable and the average behavior does not change over time. Therefore, the simulation model is valid and working properly.

Question 8

To generate 80 random numbers in an Excel simulation,the "=RAND()" function is first typed into the C2 cell on an Excel spreadsheet.C2 is then copied and pasted in a rectangular area on the spreadsheet to cover the cells:
A)C2:G13.
B)C2:J11.
C)C2:F20.
D)C2:D40.

Accepted Answer

To generate 80 random numbers, we need to cover a rectangular area that includes 80 cells. Option B covers a total of 80 cells, which is the correct number for the simulation. Options A, C, and D do not cover 80 cells, and therefore, are not suitable for the simulation.

Question 9

Steady state occurs when the simulation is repeated over enough time that the average results for performance measures remain constant.

Accepted Answer

Steady state is reached when the system has reached a consistent state and the average results for performance measures do not change significantly over time. This indicates that the system has stabilized and further simulation runs are unlikely to provide significantly different results.

Question 10

A number that has the same probability of being selected as any other number is a(n)________.

Accepted Answer

The answer of A number that has the same probability...

Question 11

This table shows the distribution of grades in an operations management class.  Add a column to the table that shows the cumulative probability and indicate what letter grade is obtained when the RAND()function is equal to 0.5548
A)A
B)B
C)C
D)D

Accepted Answer

The answer of This table shows the distribution of grades...

Question 12

________ are random events that the decision maker cannot control.

Accepted Answer

The answer of ________ are random events that the decision...

Question 13

If the difference in results between different simulation runs results in a mathematical difference in system performance,the difference is said to be ________.

Accepted Answer

The answer of If the difference in results between different...

Question 14

One hundred monkeys are typing in Excel spreadsheets when one of them enters =NORM.S.INV(RAND())What is the result of this monkey's function?
A)the number zero
B)random numbers evenly distributed from 0 to 1 inclusive
C)probabilities of the normal distribution function
D)z-scores from the standard normal distribution

Accepted Answer

The function =NORM.S.INV(RAND()) returns z-scores from the standard normal distribution. Therefore, the best choice is D.

Question 15

________ uses random numbers to generate simulation events.

Accepted Answer

The answer of ________ uses random numbers to generate simulation...

Question 16

In Excel,the RAND()function generates either a 0 or a 1,purely at random.

Accepted Answer

The RAND() function generates a random decimal number between 0 and 1, not just 0 or 1.

Question 17

________ occurs when the simulation is repeated over enough time that the average results for performance measures remain constant.

Accepted Answer

The answer of ________ occurs when the simulation is repeated...

Question 18

When using Excel for simulation,it is important to freeze the random numbers used in order to compare the effectiveness of different policies.To do this,you must select the cells holding the random numbers with the mouse,click Edit/Copy at the top of the spreadsheet,and:
A)click Edit/Paste Special and select the Values option.
B)click Edit/Paste to freeze the cells.
C)click Edit/Paste Special and select the Formulas option.
D)move to a different section of the spreadsheet,then click Edit/Paste to freeze the cells.

Accepted Answer

Selecting the Values option in Paste Special will replace the random numbers with their current values, effectively freezing them. This allows for consistent comparison of different policies based on the same set of random numbers.

Question 19

Why would data need to be collected prior to conducting a simulation?

Accepted Answer

The answer of Why would data need to be collected...

Question 20

A variable that is controlled by the decision-maker and will change from one run to the next as different events are simulated is a(n)________.

Accepted Answer

The answer of A variable that is controlled by the...

Quiz 20: Simulation

How can random numbers be generated?

In Excel,typing the function ________ will generate random numbers within the interval 0 to 1.

This table shows the distribution of grades in an operations management class. Add a column to the table that shows the cumulative probability and indicate what letter grade is obtained when the RAND() function is equal to 0.7406

If the data needed to set up a simulation are available in company records,the technique used to obtain them is called ________.

This table shows the distribution of grades in an operations management class. Add a column to the table that shows the cumulative probability and indicate what letter grade is obtained when the RAND() function is equal to 0.982245

To generate 100 random numbers in an Excel simulation,the "=RAND() " function is first typed into the A1 cell on an Excel spreadsheet.A1 can then be copied and pasted in a rectangular area on the spreadsheet to cover the cells:

A simulation model is used to test the impact of the number of sample customers at a supermarket.As the model is run,the decision maker watches the average number of customers in the store rapidly increase from zero until it levels off and holds a constant value.The simulation model is:

To generate 80 random numbers in an Excel simulation,the "=RAND() " function is first typed into the C2 cell on an Excel spreadsheet.C2 is then copied and pasted in a rectangular area on the spreadsheet to cover the cells: