Chapter 2: Binomial Distribution

A basketball player is trying to improve his consecutive free throw shots. Every day, he would shoot a set of ten free throws and record the results. He has been shooting shots all summer and recorded his data in an excel spreadsheet. The excel has been provided

1. Based on the collected data, what is the probability of the basketball player shooting three shots?

2. Based on the collected data, what is the probability of the basketball player making a shot?

3. Based on the collected data, what P(X=x) will have to highest possibility of happening? (For example, P(X=1), P(X=2),P(X=3) to P(X=10, which is the best).

4. Create an excel simulation using the binomial distribution based on the collected data probability of success found in question 2. The simulation should have 10,000 rows. If you could not determine the answer for number 2, use a P = .5 for success.

5. Based on the simulation, what is the probability of success with the highest probability?

6. Calculate the analytical solution for the P(X=x) you stated has the highest probability of success in question 5.

you can creat any trials for free throw in excel for 1000 days 10 times each day i can't upload the excel i need the steps to solve it