For this assignment, your group will utilize the preliminary data collected in the Topic 2 assignment. Considering the specific
requirements of your scenario, complete the following steps using Excel. The accuracy of formulas and calculations will be assessed. Select the appropriate discrete probability distribution. If using a binomial distribution, use the constant probability from the collected data and assume a fixed number of events of 20. If using a Poisson distribution, use the applicable mean from the collected 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 the value of X of 20% of the data, identify the value of X for the top 10% of the data, and 95% of the data lies between two values of X.
How would I Calculate and do #3 and can it be explained step by step so I can better understnd?
