Question: Using Excel how do you complete Create a simple simulation that models the toss of a fair coin. Record the results (%Heads/%Tails). Use sample sizes

Using Excel how do you complete

  1. Create a simple simulation that models the toss of a fair coin. Record the results (%Heads/%Tails). Use sample sizes of 5, 10, 30, and 100. Hint-Use the RAND() function.
  2. The arrival of email at your home email address can be categorized as family, junk, and friends. Each has an arrival rate: family5/day; junk4/day; friends3/day. Create a simulation that provides you with a profile 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 it for 100 days.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!