LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Rijan
 
Posts: n/a
Default What is mathematical equation for NORMDIST (x,mean,standard_dev,TR

Would someone tell me the exact mathematical equation for NORMDIST
(x,mean,standard_dev,TRUE)?

I have found an equation in Excel Help which is for cumulative = FALSE and
written that the formula should integrate from negative infinity to x for
TRUE.

There are some equations for such integration in mathworld.wolfram.com with
error function (erf) but it does not give the same result as does the Excel
give.

For example, NORMDIST(0.3,4,1.5,TRUE) = 0.006819 (from Excel) and now I
wanted to know the equation which gave that value (0.006819). Any help in
this regard would be highly appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
equation editor lesley Excel Worksheet Functions 3 May 4th 05 11:59 PM
Rounding in Trendline Equation Phil Hageman Charts and Charting in Excel 3 January 15th 05 01:15 AM
Logarithmic Trendline Equation Phil Hageman Charts and Charting in Excel 2 January 13th 05 11:55 AM
calculate non linear equation lines using excel Dawn Excel Discussion (Misc queries) 3 January 10th 05 01:09 PM
equation problem Dinie Excel Worksheet Functions 1 December 8th 04 06:26 PM


All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"