Use the Information Below to Answer the Following Question(s)

question 17

Multiple Choice

Use the information below to answer the following question(s) .
Below is a spreadsheet for Trance Electronics.

Suppose that the project manager of Trance Electronics has identified the following uncertain variables in the model and the distributions and parameters that describe them, as follows:
: normal with mean of 2,000,000 units and standard deviation of 400,000 units.
: uniform between $600,000,000 and $800,000,000.
: lognormal with mean of $150,000,000 and standard deviation $30,000,000.
: triangular with minimum = 2%, maximum = 6%, and most likely = 3%.
: triangular with minimum = 15%, maximum = 25%, and most likely = 20%.
The number of trials per simulation is equal to 10,000 at a Sim.Random Seed of 2.Run the simulation and answer the following questions using the Risk Solver Platform.
-What is the coefficient of variation obtained from the simulation results of the net present value?

• A)1.78392
• B)-2.23958
• C)-1.43288
• D)2.87645

---

Definitions:

Z-score

A statistical measure that describes a value's position relative to the mean of a group of values, expressed in units of standard deviation.

Z

In statistics, often represents the standard score, which is the number of standard deviations a data point is from the mean.

Percentage

A way of expressing a number as a fraction of 100, used to compare proportions.

Normal Model

A theoretical distribution with a bell-shaped curve, symmetrical about the mean, used in statistics to describe how values of a variable are spread or distributed.