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
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
My calculator said it, I believe it, that settles it
