For this assignment, your group will utilize the preliminarydata collected in the Topic 2 assignment. Considering the specificrequirements of your scenario, complete the following steps usingExcel. The accuracy of formulas and calculations will beassessed.
- Select the appropriate discrete probability distribution. Ifusing a binomial distribution, use the constant probability fromthe collected data and assume a fixed number of events of 20. Ifusing a Poisson distribution, use the applicable mean from thecollected data.
- Identify the following: the probability of 0 events occurring,the probability of <5 events occurring, and the probability of≥10 events occurring.
- Using the mean and standard deviation for the continuous data,identify the applicable values of X for the following: Identify thevalue of X of 20% of the data, identify the value of X for the top10% of the data, and 95% of the data lies between two values ofX.
How would I Calculate and do #3 and can it be explained step bystep so I can better understand ?
