math guruu excel

  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: family—5/day; junk—4/day; friends—3/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.

Leave a Comment