CLC – Discrete and Normal Distribution Analysis My Group Group Forum This is a Collaborative Learning Community (CLC) assignment. The purpose of this assignment is to complete a discrete and normal distribution analysis. Part 1: 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.

This is a Collaborative Learning Community (CLC) assignment.

The purpose of this assignment is to complete a discrete and normal distribution analysis.

Part 1:

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.

Part 2

Provide a 250-500 word summary that includes the following.

• Interpretation of various probability distributions that were calculated, including justification of the type of distribution selected.
• Interpretation of the results of the various value of X calculations that were completed.

Submit the Excel spreadsheet and Word summary document.

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are required to submit this assignment to LopesWrite. Refer to the LopesWrite Technical Support articles for assistance.

RUBRIC