Economics Assignment on Project 2: Distributions

Project 2: Distributions
Due date: June 8
th 2020, 11:59 PM
1. Peruse (check out) my example. I entered my data in sheet 1 on row 1 (52% is pitiful). Then, I compute
the number of successes in 10 trials beginning from the first shot and entered that number (4 makes) in
cell B2. I continued by computing the number of successes from attempt 2 through attempt 11. Again,
this equals 4 and I entered that in B3. Continuing along, I have a row from B2 to CN2 with the numbers
of makes in 10 trials. Next, I computed the frequency of each of these numbers and entered that where
it is labeled “binomial distribution. Finally, I plotted the frequencies. It’s somewhat bell-shaped, but not
exactly. The reason is, of course, that this is only a sample.
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 you had 1 success.
Etc.
f. Plot the binomial distribution. (Successes along with 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 the first attempt.”
e. Count the frequency of “success on the 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 dropbox. Specifically, you will turn in a spreadsheet file.