Problem
I. Use the Bernoulli distribution in the data analysis add-in to simulate the flip of coin 50 times. Generate a random seed using =RAND(). If you consider a value of one to be a head, use the =SUM() function to determine the number of head and tails flipped.
II. Use the binomial distribution in the data analysis add-in to simulate the distribution of men and women among the next 10 arrivals at an emergency room, assuming that, on average, 6 people out of 10 who arrive are men. Generate a random seed using =RAND(). Simulate the arrival of 50 sets of 10 people. Use the =COUNTIF() function to determine how many of the 50 sets of 10 people will be men and how many will be 9 men and 1 woman.
III. Use the discrete distribution in the data analysis add-in to simulate the roll of a six-sided die 50 times. Generate a random seed using =RAND(). Use the =COUNTIF() function to determine how many of the 50 rolls will be produce a six.