First we will learn how to evaluate binomial distribution with the help of Excel. Let's flip...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
First we will learn how to evaluate binomial distribution with the help of Excel. Let's flip a coin n times and count how many tails we are going to get. If n=0, then no coin is tossed and the only option is 0 tails. Therefore P(0)-1, the mean is 0 and the standard deviation is 0. We are going to do a simple table for n=0. First we will define columns. Click on cell A1 and type X for our variable. Click on enter. Then click on 81 and input p(x) for probability. Click on cell A2 and type 0. Click on enter. Click on cell 82 and type 1. That completes the table. Now let's also evaluate mean and standard deviation. Click on cell D1 and type mean. Click on cell E1 and type variance. Click on cell F1 and type SD. Let's put in the formulas. Click on cell D2 and type =a2*b2. Click on cell E2 and type=b2*(a2-d2)^2. Click on cell F2 and type sartje2). We will indicate that we have a binomial distribution by clicking on H1 and typing in n, then we'll go to H2 and type 0. We'll go to 11 and type p and then we'll go to 12 and type=1/2. Now we will do n=1. First we will define columns. Click on cell A4 and type X for our variable. Then click on B4 and input p(x) for probability. Click on cell 04 and type mean.. Click on cell E4 and type variance. Click on cell F4 and type SD. When n=1 the only two options are 0 tails and 1 tail. Thus, we click on cell A5 and type 0 and we click on cell A6 and type 1. Let's now use binomial formula to evaluate probabilities. Click on cell 85 and type BINQMRIST(0,1,1/2,FALSE). Click on enter. In this formula for binomial distribution there are four parameters, the first means we are looking for the probability of getting 1 tail. The second means we are flipping 2 coins. The third means that the probability of getting a coin in any flip is %. The last parameter False says that we are not looking into cumulative probability. We may use True instead when we are looking for the median for example, but that is not the topic here. Now that we learned that, we will evaluate probability of getting 1 coin. Click on cell 86 and type =BINOMRIST(1,1,1/2,FALSE). We will indicate that we have a binomial distribution by clicking on H4 and typing in n, then we'll go to H5 and type 1. We'll go to 14 and type p and then we'll go to 15 and type 1/2. Now t's evaluate mean and standard deviation.. Click on cell D4 and type mean. Click on cell E4 and type variance. Click on cell F4 and type SD. Click on cell D5 and type =h5*15. Click on cell ES and type =h5*15*(1-15). Click on cell F6 and type=artles). Let's now do n=2. We will indicate that we have a binomial distribution by clicking on H8 and typing in n, then we'll go to H9 and type 2. We'll go to 18 and type p and then we'll go to 19 and type=1/2. Click on cell AB and type X for our variable. Then click on 88 and input p(X) for probability. Click on cell 08 and type mean. Click on cell EB and type variance. Click on cell F8 and type SD. When n=2 the only three options are 0, 1 and 2 tails. Thus, we click on cell A9 and type 0, we click on cell A10 and type 1 and we click on cell A11 and type 2. Let's now use binomial formula to evaluate probabilities. Click on cell 89 and type BINOMPIST(0,2,1/2,FALSE). Click on enter. The second parameter here means we are flipping 2 coins Click on cell 810 and type BINOMRIST(1,2,1/2,FALSE). Click on cell 811 and type -BINOMAIST(2,2,1/2,FALSE). Now let's evaluate mean and standard deviation. Click on cell 08 and type mean. Click on cell E8 and type variance. Click on cell F8 and type SD. Click on cell D9 and type =h9*19 Click on cell E9 and type =h9*19*(1-19). Click on cell F9 and type -sqrt(e). We now study what happens when flipping 3 coins. Click on cell A13 and type X for our variable. Then click on 813 and input p(x) for probability. Click on cell D13 and type mean.. Click on cell E13 and type variance. Click on cell F13 and type SD.. We will indicate that we have a binomial distribution by clicking on H13 and typing in n, then we'll go to H14 and type 3. We'll go to 113 and type p and then we'll go to 114 and type=1/2. When flipping 3 coins, you can get 0, 1, 2 or 3 tails. Thus, we click on cell A14 and type 0, we click on cell A15 and type 1, we click on cell A16 and type 2 and we click on cell A17 and type 3. Let's now use binomial formula to evaluate probabilities. Click on cell B14 and type =BINOMPIST(0,3,1/2,FALSE). Click on enter. The second parameter here means we are flipping 3 coins.. Click on cell B15 and type BINOMDIST(1,3,1/2, FALSE). Click on cell B16 and type =BINOMPIST(2,3,1/2,FALSE). Click on cell B17 and type BINQMRIST (3,3,1/2,FALSE). Now let's evaluate mean and standard deviation.. Click on cell D13 and type mean. Click on cell E13 and type variance. Click on cell F13 and type SD. Click on cell D14 and type =h14*114. Click on cell E14 and type =h14 114 (1-114). Click on cell F14 and type satt(e14). Exercises Exercise 1. Make the binomial probability distribution table for n=4 and p=1/2. Exercise 2. Make the binomial probability distribution table for n=5 and p=1/2. Exercise 3. Make the binomial probability distribution table for n-6 and p=1/3. Exercise 4. Make the binomial probability distribution table for n=8 and p=1/3. First we will learn how to evaluate binomial distribution with the help of Excel. Let's flip a coin n times and count how many tails we are going to get. If n=0, then no coin is tossed and the only option is 0 tails. Therefore P(0)-1, the mean is 0 and the standard deviation is 0. We are going to do a simple table for n=0. First we will define columns. Click on cell A1 and type X for our variable. Click on enter. Then click on 81 and input p(x) for probability. Click on cell A2 and type 0. Click on enter. Click on cell 82 and type 1. That completes the table. Now let's also evaluate mean and standard deviation. Click on cell D1 and type mean. Click on cell E1 and type variance. Click on cell F1 and type SD. Let's put in the formulas. Click on cell D2 and type =a2*b2. Click on cell E2 and type=b2*(a2-d2)^2. Click on cell F2 and type sartje2). We will indicate that we have a binomial distribution by clicking on H1 and typing in n, then we'll go to H2 and type 0. We'll go to 11 and type p and then we'll go to 12 and type=1/2. Now we will do n=1. First we will define columns. Click on cell A4 and type X for our variable. Then click on B4 and input p(x) for probability. Click on cell 04 and type mean.. Click on cell E4 and type variance. Click on cell F4 and type SD. When n=1 the only two options are 0 tails and 1 tail. Thus, we click on cell A5 and type 0 and we click on cell A6 and type 1. Let's now use binomial formula to evaluate probabilities. Click on cell 85 and type BINQMRIST(0,1,1/2,FALSE). Click on enter. In this formula for binomial distribution there are four parameters, the first means we are looking for the probability of getting 1 tail. The second means we are flipping 2 coins. The third means that the probability of getting a coin in any flip is %. The last parameter False says that we are not looking into cumulative probability. We may use True instead when we are looking for the median for example, but that is not the topic here. Now that we learned that, we will evaluate probability of getting 1 coin. Click on cell 86 and type =BINOMRIST(1,1,1/2,FALSE). We will indicate that we have a binomial distribution by clicking on H4 and typing in n, then we'll go to H5 and type 1. We'll go to 14 and type p and then we'll go to 15 and type 1/2. Now t's evaluate mean and standard deviation.. Click on cell D4 and type mean. Click on cell E4 and type variance. Click on cell F4 and type SD. Click on cell D5 and type =h5*15. Click on cell ES and type =h5*15*(1-15). Click on cell F6 and type=artles). Let's now do n=2. We will indicate that we have a binomial distribution by clicking on H8 and typing in n, then we'll go to H9 and type 2. We'll go to 18 and type p and then we'll go to 19 and type=1/2. Click on cell AB and type X for our variable. Then click on 88 and input p(X) for probability. Click on cell 08 and type mean. Click on cell EB and type variance. Click on cell F8 and type SD. When n=2 the only three options are 0, 1 and 2 tails. Thus, we click on cell A9 and type 0, we click on cell A10 and type 1 and we click on cell A11 and type 2. Let's now use binomial formula to evaluate probabilities. Click on cell 89 and type BINOMPIST(0,2,1/2,FALSE). Click on enter. The second parameter here means we are flipping 2 coins Click on cell 810 and type BINOMRIST(1,2,1/2,FALSE). Click on cell 811 and type -BINOMAIST(2,2,1/2,FALSE). Now let's evaluate mean and standard deviation. Click on cell 08 and type mean. Click on cell E8 and type variance. Click on cell F8 and type SD. Click on cell D9 and type =h9*19 Click on cell E9 and type =h9*19*(1-19). Click on cell F9 and type -sqrt(e). We now study what happens when flipping 3 coins. Click on cell A13 and type X for our variable. Then click on 813 and input p(x) for probability. Click on cell D13 and type mean.. Click on cell E13 and type variance. Click on cell F13 and type SD.. We will indicate that we have a binomial distribution by clicking on H13 and typing in n, then we'll go to H14 and type 3. We'll go to 113 and type p and then we'll go to 114 and type=1/2. When flipping 3 coins, you can get 0, 1, 2 or 3 tails. Thus, we click on cell A14 and type 0, we click on cell A15 and type 1, we click on cell A16 and type 2 and we click on cell A17 and type 3. Let's now use binomial formula to evaluate probabilities. Click on cell B14 and type =BINOMPIST(0,3,1/2,FALSE). Click on enter. The second parameter here means we are flipping 3 coins.. Click on cell B15 and type BINOMDIST(1,3,1/2, FALSE). Click on cell B16 and type =BINOMPIST(2,3,1/2,FALSE). Click on cell B17 and type BINQMRIST (3,3,1/2,FALSE). Now let's evaluate mean and standard deviation.. Click on cell D13 and type mean. Click on cell E13 and type variance. Click on cell F13 and type SD. Click on cell D14 and type =h14*114. Click on cell E14 and type =h14 114 (1-114). Click on cell F14 and type satt(e14). Exercises Exercise 1. Make the binomial probability distribution table for n=4 and p=1/2. Exercise 2. Make the binomial probability distribution table for n=5 and p=1/2. Exercise 3. Make the binomial probability distribution table for n-6 and p=1/3. Exercise 4. Make the binomial probability distribution table for n=8 and p=1/3.
Expert Answer:
Answer rating: 100% (QA)
The given instructions can first be applied in Excel to get the following results for Exercise 1 The ... View the full answer
Related Book For
Principles of Corporate Finance
ISBN: 978-1260013900
13th edition
Authors: Richard Brealey, Stewart Myers, Franklin Allen
Posted Date:
Students also viewed these programming questions
-
A telephone exchange operator assumes that 8 % of the phone calls are wrong numbers. If the operator is accurate, what is the probability that the proportion of wrong numbers in a sample of 4 2 8...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Find the 2- and y-intercepts of the graph of the function f(x)=-3x+7 +6. Enter your answers as points, (a, b). Enter the -intercepts in order of increasing z-value. If there are no z-intercents,...
-
paraphrase the following two passages using narrative in-text citations: 1.Those who teach ethics don't need to look far for lessons. Every day there's fresh scandal: Google is in hot water for how...
-
If the principal quantum number n were limited to the range from 1 to 6, how many elements would we find in nature?
-
How does expensing a capital expense immediately affect taxes/cash flows as it pertains to IRR vs Depreciation? "That capital expense can be expensed immediately and will thus reduce taxable income...
-
Identify the mode for each of the following sets of data: a. 7, 3, 7, 1, 7 b. 3, 1, 1, 2, 3, 3 c. 8, 22, 8, 10, 9, 8, 12, 7, 8 d. 5, 3, 6, 4, 5, 3, 1, 5, 2, 5, 6, 5 e. 11, 9, 13, 6, 14, 12, 7, 12,...
-
Suppose SSC has decided to distribute $50 million, which it presently is holding in very liquid short-term investments. SSCs value of operations is estimated to be about $1,937.5 million. SSC has...
-
Explore the type of accounting system used in selected organizations in Jamaica. a . Create an instrument to conduct an interview with an accounting officer within the selected organization to obtain...
-
The following transactions occurred in November 202X for J. Kingslys Technical Staffing Agency: The chart of accounts for J. Kingsly Technical Staffing Agency is as follows: Your task is to do the...
-
{fill_regular) was the first scientist to propose a model for the structure of an atom.
-
Modify HashST to use a resizing array so that the average length of the list associated with each hash value is between 1 and 8 .
-
Apply the scientific method to develop and validate a hypothesis about the order of growth of the running time of the following code fragment, as a function of the argument \(n\). public static int...
-
Suppose you use a stack instead of a queue for breadth-first search in PathFinder. Does it still compute a path from the source to each vertex? Does it still compute shortest paths? In each case,...
-
True or false: At some point during breadth-first search the queue can contain two vertices, one whose distance from the source is 7 and one whose distance is 9.
-
Is the following class immutable?} import java.util.Date; public class Appointment { } private Date date; private String contact; public Appointment (Date date) { this.date date; this. contact =...
-
Compare and interpret running time analysis of Iterative sorting algorithm, divide and conquer algorithms and non-comparison based algorithm properly
-
The activities listed in lines 2125 serve primarily as examples of A) Underappreciated dangers B) Intolerable risks C) Medical priorities D) Policy failures
-
Suppose that the AMAT bond was issued at face value and that investors continue to demand a yield of 5.85%. Sketch what you think would happen to the bond price as the first interest payment date...
-
1. Prepare a memo for Mr. van Wie explaining how RA would invest to minimize both risk and exposure to changing interest rates. Give an example of a portfolio that would accomplish this objective....
-
Calculate the NPV of the proposed overhaul of the Vital Spark, with and without the new engine and control system. To do the calculation, you will have to prepare a spreadsheet table showing all...
-
Which mechanism of bacterial genetic transfer does not require recombination with the bacterial chromosome?
-
Explain why small deletions and duplications are less likely than large ones to have a detrimental effect on an individuals phenotype. If a small deletion within a single chromosome happens to have a...
-
Explain how polytene chromosomes of Drosophila are produced, and describe the six-armed structure they form.
Study smarter with the SolutionInn App