Question 598289
<font face="Times New Roman" size="+2">


Don't know what "BINOMIST" is.  Sounds like some sort of new spray deodorant or "up the nose" decongestant or something.


Now if you want to know about the spreadsheet function BINOMDIST, that is another story altogether.  The first thing you have to do is find the probability of success on any given trial.  Secondly, you can't use this function calculate "less than ..." some number of successes, you have to calculate "less than or equal..." to something.  Here you want less than 3, so you calculate less than or equal to 2.


Pick an empty cell in your spreadsheet (either in Excel on a Windows machine or Numbers on a Mac).  Type


*[tex \LARGE \ \ \ \ \ \ \ \ \ \ =BINOMDIST(2,6,p,TRUE)]


replacing "p" with the probability of success on any individual trial.  The "TRUE" part means "cumulative" and that is what gets you the "less than" part of "less than or equal to 2"  If you put "false" in there, you get the probability of exactly 2.


John
*[tex \LARGE e^{i\pi} + 1 = 0]
My calculator said it, I believe it, that settles it
<div style="text-align:center"><a href="http://outcampaign.org/" target="_blank"><img src="http://cdn.cloudfiles.mosso.com/c116811/scarlet_A.png" border="0" alt="The Out Campaign: Scarlet Letter of Atheism" width="143" height="122" /></a></div>
</font>