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?

Sale on SolutionInn
  • CreatedAugust 19, 2015
  • Files Included
Post your question