2. Binomial Distribution: number of successes in n trials. (If you are a “spreadsheet wizard,” you can have the spreadsheet make these calculations.) Here is the manual way to do it.
a. Count the number of successes in the first 10 attempts.
b. Count the number of successes from attempt 2 through attempt 11.
c. Count the number of successes from attempt 3 through attempt 12.
Etc.
d. Count the number of times (frequency) that you had 0 successes.
e. Count the number of times that your had 1 success.
Etc.
f. Plot the binomial distribution. (Successes along the horizontal – frequency along the vertical)
g. Compute the mean and standard deviation.
3. On sheet 2 is my geometric distribution. Here again, I entered the data on row 1. Then I compute the number of trials until success. You can see that my first make was on the second try; so the number of trials until success (starting from the first shot) is 2. I again calculated the frequencies and plotted the distribution. It looks fairly close to geometric.
4. Geometric Distribution: number of attempts until next success.
a. Count the number of attempts until your first success.
b. Starting from the second attempt, count the number of trails until your first success. (note: if you first success is on attempt 6, then the answer to part a. is 6, and the answer to part b. is 5.)
etc.
d. Count the frequency of “success on first attempt.”
e. Count the frequency of “success on second attempt.”
Etc.
f. Plot the geometric distribution (attempts on the horizontal – frequency along the vertical)
g. Compute the mean and standard deviation.
5. Turn your work into the dropbox. Specifically, you will turn in a spreadsheet file.
jinnniubaobao
project_2.docx
0
