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

(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?

S - 20 a/ 2/V100