 that got me a $500 sale versus a $100 sale or something like that we're saying did I make a sale or did I not make a sale success being defined in this case if we made the sale non-success if we did not if you're talking about a coin flipping situation then we will have heads or tails so the question is in a coin flipping situation did the success would be defined as either heads or tails whichever you want to choose non-success would be the other for the probability of quote success which is going to be represented by P is the same for each outcome so when you talk about a coin flipping situation then if it's a fair coin the probability of success 50% each coin flip if you're talking about a sales call situation or a coin that is not fair for example then you could the sales call you can have the probability of success for each call is usually much lower if you're especially if you're cold calling for sales you might only have like a 10% or even lower probability of making a sale on any particular call but that 10% were imagining would be constant for each of the calls so if these conditions are met then you could have a binomial type of distribution and we can use this equation we're not going to go into the equation in too much detail here because I don't want to be too intimidated by the equation because the idea would be that once the equation has been figured out to give us the curve of a binomial distribution then we can apply that if we find that that being applicable in our actual real-life situation then we can apply that using our excel functions and our excel graphs and if you wanted to type this in of course you can go to the insert and you can go into the equation and then you can make an ink equation we've seen in prior presentation so I won't do the whole thing again here but just know any Microsoft product you can kind of type in a mathematical equation this way and that way you can you can represent that equation in in excel so so so or any any Microsoft product so it's a kind of a new nice tool to have so let's go on over and approximate some data so we're going to have the number is going to be in and then we've got P is going to be the percent of of likelihood P is the same for each outcome which which is the the the probability of success for each outcome so let's imagine what we want to do now is plot out the binomial distribution and make a graph from it and see how the graph changes if we change the variables such as N and P as we do this it might be useful to envision a scenario so let's imagine that we have that sales call scenario where N represents the number of calls and P represents the probability of success success in this case being that we made a sale on the sales call failure being that we don't have a sale on the sales call so if I was to plot this out we're going to say that X is on the left so X is going to be zero through five notice that this sequence that we're putting into excel I could put a zero in a one and then use the fill handle a copy it down to five or just type in five but if we use this sequence function we could say equals sequence and then the number of rows is going to be this number five plus one because I actually want to add a zero and then comma comma to the starting point of zero the reason this sequence function is useful is because sometimes it's faster if you have a whole lot of columns and also you can change the number of rows automatically now by changing this end so if I change this end this will change automatically so that's kind of a useful tool sometimes to use within excel the pfx is going to be out