Question: Open a new Excel spreadsheet. Name one tab Binomial and another tab Poisson. 1. In the Binomial tab, use Excel's Data Analysis > Random Number
Open a new Excel spreadsheet. Name one tab Binomial and another tab Poisson. 1. In the Binomial tab, use Excel's Data Analysis > Random Number Generation to create 100 binomial random numbers with n = 30 and = .25. In the spreadsheet calculate the sample mean and sample standard deviation. In the spreadsheet compare the calculations to the theoretical values. 2. In the Poisson tab, use Excel's Data Analysis > Random Number Generation to create 100 Poisson random numbers with = 2.5. In the spreadsheet calculate the sample mean and standard deviation. In the spreadsheet compare the calculations to the theoretical values. Make sure to save your changes and upload your spreadsheet here
Step by Step Solution
There are 3 Steps involved in it
The instruction to save your changes and upload your spreadsheet here suggests that the question is incomplete as it requires an action that isnt feas... View full answer
Get step-by-step solutions from verified subject matter experts
