The above chart on the right shows the Binomial Distribution Probability Mass Function for 100 tosses of a coin. C n k pk 1 - pn k. Entering the probability formula As a result the probability in cell C11 is 068 or 68 which is the probability that product sales is between 50 and 80.
R is the discount rate.
How to use the BINOMDIST function in Excel. USING BINOMDIST IN EXCEL There are three parameters for every binomial problem type. These parameters always are entered in this order for every binomial function in Excel. Where p is the probability of an up move which is determined using the following equation.