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
- 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.
- 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
