Software Venture Consulting
ToMarket

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Brian Dunning
Contact me | vCard


Brian on CNN
Brian on CNN


Brian on CBS Radio


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 FileMaker Pro Custom Functions

Search  |  List  |  Show Random  |  Upload  |  Add This to Your Site

BinomDist ( successes ; trials ; probability ; cumulative )

Michael Horak, *COMMENT Visual Realisation
http://comment.cjb.net

Returns the binomial probability distribution of obtaining the number of successes out of a fixed number of trials, where the result of each trial can be only success or failure, and the probability of success is constant throughout the experiment. BinomDist can calculate the probability that two out of the next three babies born will be male.

Sample Input:
BinomDist ( 10 ; 20 ; 0.5 ; 0 )
BinomDist ( 10 ; 20 ; 0.5 ; 1 )
Sample Output:
0.1761970520019531
0.5880985260009766


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

if you have myFMbutler's Clip Manager installed

Description:

Returns the binomial probability distribution of obtaining the number of successes out of a fixed number of trials, where the result of each trial can be only success or failure, and the probability of success is constant throughout the experiment. BinomDist can calculate the probability that two out of the next three babies born will be male.

Depending on the cumulative parameter, the BinomDist function returns either the individual probability of obtaining exactly the number of successes, or the cumulative probability of obtaining at most the number of successes.

The BinomDist function parameters are:
successes - the number of successes in trials;
trials - the number of independent trials;
probability - probability of success in each trial;
cumulative - a logical value that determines the form of the function: if cumulative is TRUE, BinomDist returns the cumulative distribution function, which is the probability of obtaining at most the number of successes; if FALSE, it returns the probability mass function, which is the probability of obtaining exactly the number of successes.

Example:
The flip of a coin can only result in 'heads' or 'tails'. The probability of any individual flip being 'heads' is 0.5.

The probability of getting exactly 10 'heads' results out of 20 flips is:
BinomDist ( 10 ; 20 ; 0.5 ; 0 ) = 17.62%

The probability of getting 10 or less 'heads' results out of 20 flips is:
BinomDist ( 10 ; 20 ; 0.5 ; 1 ) = 58.81%

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

digg this page | del.icio.us this page

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. PVofFV ( FutureVal , Interest , Term )
  (Sat, May 10, 6:52pm)
2. Edate ( thedate ; months )
  (Sat, May 10, 5:21pm)
3. FormatDate( DatetoFormat )
  (Thu, May 08, 6:05pm)

RSS Feed of Custom Functions

Quick Poll...
Are you mainly Mac
or mainly Windows?
 • Mac
 • Windows
View the answers

ChartMaker Pro 7

Charts and graphs in your FileMaker 5/6/7/8 solution without a plug-in. Click here.

Custom Function Authors:
Link to all of your own custom functions on this site with the following URL:
http://www.briandunning.com/filemaker-custom-functions/results.php?author=Your Name Here