Microsoft Office Tutorials and References

In Depth Information

large
then the second event has equal chances of 11, 13, 14, and 15 as outcomes.

Create a simulation that provides a risk proﬁle of outcomes. The simulation

should replicate the experiment a minimum of 300 times.

9. Create a VLOOKUP that:

a. Allows a user to enter a percent (0 to 100%) and returns a categorical value

based on the following data:

0–30%

31–63%

64–79%

80–92%

93–100%

A

B

C

D

E

b. For the same data above, create a VLOOKUP that returns a categorical value

for a
randomly
generated %. Hint-Use the RAND() function.

c. Expand the table so that the category A and B is deﬁned as
Good
,Cas

OK
, and D and E as
Terrible
. With this new three row table return the new

outcomes (
Good
, etc.) for exercise (a) and (b) above.

10. Create a simulation of a simple income statement for the data elements shown

below and produce a risk proﬁle and summary data for proﬁt (average, max,

min, standard deviation, etc.):

a. Revenue Normally distributed mean of $140 k and standard deviation of

$26 k

b. COGS is a % of Revenue with outcomes of 24, 35, and 43%, all equally

likely

c. Variable costs % of Revenue with outcome 35% one half as likely as

outcome 45%

d. Fixed costs $20 k constant.

11. The arrival of email at your home email address can be categorized as

family
,
junk
, and
friends
. Each has an arrival rate: family—5/day; junk—4/day;

friends—3/day.

a. Create a simulation that provides you with a proﬁle of total, daily email

arrival. What is the probability that you will receive 0 emails, 3 emails or

less, 15 or more emails, and between 5 and 15 emails. Hint-Use the Poisson

() function and replicate for 100 days.

b.

If you read every email you receive and the time to read the categories is

that shown below, what is the distribution of minutes spent per day reading

email.

i. Family email Normal distribution, mean 5 minutes and standard devia-

tion 2

ii. Junk email Discrete 0.5 minutes 80% and 3 minutes 20%

iii. Friends Continuous Uniform from 3.5 to 6.5 minutes.

12.
An advanced problem
—Father Guido Aschbach, pastor of Our Lady of

Perpetual Sorrow Church, is planning a weekly (Sunday after mass) charity

Search JabSto ::

Custom Search