Binomial Distribution Function in Excel

This video demonstrates using the binomial distribution function in Microsoft Excel (BINOM.DIST). This function determines the probability of a specified number of successes given a specified number of trials and the probability that any given trials will result in a success.

[meganblackwell]

The visual aides in this video were particularly helpful. It made me think about the realistic implications of my research proposal and how detailed each of the steps are.

[EMILY]

This video aided in my recollection of binomial distribution. As a visual learner, watching this function used in excel assisted in my understanding of probability of success in trials.

[tamarabakergibbons]

The results really were sensitive to the probability. I wouldn't have expected a difference that large between 50% and 60%. Thank you for the video Dr.Grande.

[virginiamurrey]

I have not viewed binomial distributions in a while. this video was a great "brush-up" tool and refresher course.

[danielleduboski]

This is another very helpful video to see how to use excel in research. The explanations are easy to follow.

[jpincinjr]

I can appreciate the conciseness of this video. I think it would have been very easy to drag this out if one wasn't careful. It seems that this would be useful as research is being planned out. Another example of Excel being very useful in research applications.

[rachelfoster]

I liked the chart that Dr. Grande used on the right side of the sheet. This always breaks it down in my mind and shows how the percentages are calculated. I also like it because it helps to illustrate what more than a number or less than a number actually includes.

[Mjthfdj]

Once again excel proves to be a great tool. This looks to be more for quantitative research. I appreciated the chart. It was very informative.

[rebeccameece]

I was happy to see this video demonstrate the binomial distribution function in Excel. I have never seen this before so it was a nice thing to learn. The chart was nice to see, as I am a visual learner, as others in the class have stated as well. I enjoyed watching this video.

[oliviahylton]

I appreciate the fact that you took the time to break down the binomial distribution and demonstrate how you got each probability. Excel formulas have always confused me so the step-by-step instruction allowed me to really understand this function.

[bethanyelstrom]

This was a great example.  There are only four possibilities for the outcome.  Again it was very helpful to see the formula calculated and how to input the data.  I'm still confused over when to use True and when to use False.  Showing how to double check the answers was a great tip.  Once you add the sum of the possibility statement you have your answer.

[ashleydorsey]

This video was informative in understanding the function of the binomial distribution. The binomial distribution determines the probability of the predictability of participants. I was unaware that the binomial distribution could be used to predict events. Also the excel spreadsheet made this easier to grasp.

[michellerobinson]

The video was easy to follow and the formula was easy to understand. I can see how the binomial distribution helps determine the probability of a successful trial.

[daniellemaldonado]

This was helpful to me and I found myself not as confused as with the two prior videos. You have four possibilities and you are figuring out for each. It was helpful to have Dr. Grande go through and explain it, while computing data. Useful!

[rhondabaileyyy]

I think this is helpful in determining how many participants should be recruited so that you have an idea of how many people will complete the study.

[toniettemorda]

The binomial distribution function seems to specify a number of trials and any given trial that would be successful. This is great to calculate the probability about participants whether < or >  were to occur.

[johnchristinadarwin]

Dr. Grande, thank you for the information. I like that you make the process very user-friendly and easy to follow.

[jackiedeleonardis]

Thank you for the breakdown of how to use this function. I thought it was interesting with a probability of 50%, that having more than 5 and less than 5 participants, the percentage was exactly the same but as soon as you increased the number of participants and the probability, the outcome changed so drastically.

[brittanyhoffman]

Thank you for sharing this video Dr. Grande. I appreciate that you showed a way to check if the answers you got were correct. Again, I haven't heard of the binomial function before watching this video, so gaining all this new information can start to be confusing and difficult in knowing if I'm doing the calculations correctly.

[mandabear]

What I liked about this and previous videos is that he goes back and shows how changing values (in this case the probabliltiy, or number of participants) affects the outcome of your calculation. I think this is important to know as it helps us to understand how all the numbers are related.