For this assignment, your group will utilize the preliminary data collected in the Topic 2 assignment....

90.2K

Verified Solution

Question

Statistics

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 ?

Answer & Explanation Solved by verified expert

4.0 Ratings (647 Votes)

STEP 1Enter your data in the blocks or cells provided in your excel sheet Take a random data of 20 size STEP 2Now you have predefined functions in excel to perform and hence by using them you can take out the mean and varianceFor that select the cells in which your data is entered and use equal to sign before typing the function name Following are some See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member