_Normdist ( z ; mu ; sigma )
Rate this function: Average rating: 4.7 (31 votes) Discuss this Custom Function
Mislav Kos, Soliant Consulting
http://www.soliantconsulting.com
FileMaker implementation of NORMDIST Excel function
Sample Input:
( 100; 100; 15 )
( 90 ; 100; 15 )
( 70 ; 100; 15 )
( 130; 100; 15 ) 

Sample Output:
0.500000001
0.252492467
0.022750062
0.977249938
Compare to Excel
0.500000000
0.252492538
0.022750132
0.977249868 

Description:
PURPOSE:
To provide a near equivalent of the NORMDIST Excel function, for when its "cumulative" parameter is set to true.
RESULT:
The cumulative probability that the observed value of a normal random variable with mean mu and standard deviation sigma will be less than or equal to parameter z.
DEPENDENCIES:
This custom function requires the _Normsdist ( z ) custom function.
NOTES:
This custom function is a FileMaker implementation of the NORMDIST function in Excel.
Caution: This custom function is ONLY AN APPROXIMATION of the Excel function;
i.e. it will calculate an approximate answer rather than the exact answer.
(Note: The same is true of the Excel function.)
The results are accurate to several decimal places, which is typically sufficient for most uses.
Also see the custom function _Normsdist ( z ).
The difference between NORMDIST and NORMSDIST:
 NORMSDIST applies to standard normal distribution.
 NORMDIST applies to any normal distribution.
 A standard normal distribution has a mean of 0 and a standard deviation of 1.
The calculation was adapted from http://www.wilmott.com/messageview.cfm?catid=8&threadid=78622.
Here are some notes on the NORMDIST Excel function from http://support.microsoft.com/kb/827371:
 The normal distribution is a continuous probability distribution whose shape is determined by its mean, mu, and standard deviation, sigma.
 The normal distribution with mean mu and standard deviation sigma is centered at mu and has half of its probability to the left of mu and half to the right.
 The /standard/ normal distribution is the special case where mu = 0 and sigma = 1.
 The probability is distributed according to the familiar bellshaped curve with the total area under the curve equal to 1.
 The probability that a value that is less than or equal to z will occur (also called cumulative probability up to z) is the area under this curve to the left of z.
 In NORMDIST, when the last argument is set to TRUE, NORMDIST returns the cumulative probability that the observed value of a Normal random variable with mean mu and standard deviation sigma will be less than or equal to z.
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
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:

Newest Custom Functions:
1. 
PreviousMonthEndDate ( myDate ) 

(Wed, Mar 07, 3:35am) 
2. 
PreviousMonthName (myDate) 

(Wed, Mar 07, 3:33am) 
3. 
FmTableFields ( tableName ; fieldsInclude ; fieldsExclude ; classExclude ; typeExclude ; prefixExclude ) 

(Fri, Mar 02, 6:32am) 
4. 
sql.getTable ( fullyQualifiedFieldObject ) 

(Thu, Feb 22, 8:36am) 
5. 
sql.getField ( fullyQualifiedFieldObject ) 

(Thu, Feb 22, 8:34am) 
6. 
FilterOut ( ListA ; ListB ) 

(Wed, Feb 21, 6:11pm) 
7. 
Char0 ( ) 

(Sun, Feb 18, 2:35am) 
8. 
CreateVCardFile ( FirstName ; LastName ; CompanyName ; Phone ; Email ; WEB ; hAddress1 ; hAddress2 ; hZip ; hCity ; hCountry ; wAddress1 ; wAddress2 ; wZip ; wCity%2 

(Sun, Feb 18, 1:50am) 

