# Question: Use Excel to generate 1 000 random integers in the range

Use Excel to generate 1,000 random integers in the range 1 through 5.

(a) What are the expected mean and standard deviation?

(b) What are your sample mean and standard deviation?

(c) Is your sample consistent with the uniform model? Discuss.

(d) Show the Excel formula you used.

(a) What are the expected mean and standard deviation?

(b) What are your sample mean and standard deviation?

(c) Is your sample consistent with the uniform model? Discuss.

(d) Show the Excel formula you used.

**View Solution:**## Answer to relevant Questions

Consider the Bernoulli model. What would be a typical probability of success (π) for (a) Free throw shooting by a good college basketball player? (b) Hits by a good baseball batter? (c) Passes completed by a good college ...Oxnard Petro Ltd. is buying hurricane insurance for its off-coast oil drilling platform. During the next five years, the probability of total loss of only the above-water superstructure ($250 million) is .30, the probability ...Write the Excel formula for each Poisson probability, using a mean arrival rate of 10 arrivals per hour. a. Seven arrivals. b. Three arrivals. c. Fewer than five arrivals. d. At least 11 arrivals. In the last 50 years, the average number of deaths due to alligators in Florida is 0.3 death per year. Assuming no change in this average, in a given year find the probability of (a) No alligator deaths; (b) At least 2 ...On New York's Verrazano Narrows bridge, traffic accidents occur at a mean rate of 2.0 crashes per day. Let X be the number of crashes in a given day. (a) Justify the use of the Poisson model. (b) What is the probability of ...Post your question