# Question: a Use Excel s Data Analysis Random Numbers to generate

(a) Use Excel's Data Analysis > Random Numbers to generate 100 Poisson-distributed random numbers with a mean of λ = 4.

(b) Make a histogram of your sample and assess its shape.

(c) Calculate descriptive statistics. __ the sample mean and standard deviation close to their Are __ intended values λ = 4 and σ = √λ = √4 = 2?

(d) Use a z test

to compare the sample mean to the desired mean. Note: Use z instead of t because the hypothesized mean μ = 4 and standard deviation σ = 2 are known.

(e) What would hap- pen if 100 statistics students performed similar experiments, assuming that Excel's random number generator is working correctly?

(b) Make a histogram of your sample and assess its shape.

(c) Calculate descriptive statistics. __ the sample mean and standard deviation close to their Are __ intended values λ = 4 and σ = √λ = √4 = 2?

(d) Use a z test

to compare the sample mean to the desired mean. Note: Use z instead of t because the hypothesized mean μ = 4 and standard deviation σ = 2 are known.

(e) What would hap- pen if 100 statistics students performed similar experiments, assuming that Excel's random number generator is working correctly?

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

Refer back to Table 15.11, which shows the distribution of the number of U.S. Supreme Court appointments per year from 19001999. Since 1999 there have been four Supreme Court appointments with one each in the years 2005, ...One-year sales volume of four similar 20-oz. beverages on a college campus is shown. (a) Make a bar chart and describe it. (b) Calculate expected frequencies for each class. (c) Perform the chi-square test for a uniform ...A supplier of laptop PC power supplies uses a control chart to track the output (in watts) of each unit produced. The pattern below shows whether each unit's output was above (a) Or below (b) The desired specification. ...Salaries of 30 randomly chosen individuals in the same occupation (only the first 3 and last 3 observations are shown). The data are from a salary equity study comparing two industries. Research question: Without assuming ...Below are results of braking tests of the Ford Explorer on glare ice, packed snow, and split traction (one set of wheels on ice, the other on dry pavement), using three braking methods. Research question: At α = .01, is ...Post your question