Software Venture Consulting

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


Contact


Privacy Policy



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

 

 FileMaker Pro Custom Functions

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

_Normsdist ( z )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 4.6  (28 votes)
  Discuss this Custom Function

Mislav Kos, Soliant Consulting
http://www.soliantconsulting.com

FileMaker implementation of NORMSDIST Excel function

Sample Input:
_Normsdist ( 5 )
_Normsdist ( 4 )
_Normsdist ( 3 )
_Normsdist ( 2 )
_Normsdist ( 1 )
_Normsdist ( 0.9 )
_Normsdist ( 0.7 )
_Normsdist ( 0.3 )
_Normsdist ( 0 )
_Normsdist ( -0.5 )
_Normsdist ( -1 )
_Normsdist ( -2 )
_Normsdist ( -3 )
_Normsdist ( -4 )
_Normsdist ( -5 )
Sample Output:
0.999999713
0.999968314
0.998650033
0.977249938
0.841344741
0.815939909
0.758036422
0.617911358
0.500000001
0.308537532
0.158655259
0.022750062
0.001349967
3.17E-05
2.87E-07

Compare to Excel:
0.999999713
0.999968329
0.998650102
0.977249868
0.841344746
0.815939875
0.758036348
0.617911422
0.500000000
0.308537539
0.158655254
0.022750132
0.001349898
3.17E-05
2.87E-07


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

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

PURPOSE:
To provide a near equivalent of the NORMSDIST Excel function.

RESULT:
The probability that the observed value of a standard normal random variable will be less than or equal to parameter z.

NOTES:
This custom function is a FileMaker implementation of the NORMSDIST 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 _Normdist ( z ; mu ; sigma ).

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 NORMSDIST Excel function from http://support.microsoft.com/kb/827369:
- NORMSDIST(z) returns the probability that the observed value of a standard normal random variable will be less than or equal to z.
- A standard normal random variable has mean 0 and standard deviation 1 (and also variance 1 because variance = standard deviation squared).

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:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 9 + 5 =
Search for Custom Functions:

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. ProperAllWords ( text )
  (Thu, Dec 14, 5:19pm)
2. MatchExist ( SourceTable.Field ; DestTable.Field ; ReturnField )
  (Thu, Dec 14, 1:07pm)
3. BVR_Format ( bvr )
  (Wed, Dec 13, 5:32pm)
4. NumberToHexadecimal(NumberValue)
  (Fri, Dec 08, 8:54am)
5. Get_BaseTable
  (Thu, Dec 07, 4:27pm)
6. JSONCreateVarsFromKeys ( json ; namespace )
  (Wed, Dec 06, 8:21pm)
7. GetTableNzme ( field )
  (Tue, Dec 05, 9:16pm)
8. TimeFormatAsText ( theTime )
  (Mon, Nov 13, 1:59pm)

RSS Feed of Custom Functions