Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
equation editor | Excel Worksheet Functions | |||
Rounding in Trendline Equation | Charts and Charting in Excel | |||
Logarithmic Trendline Equation | Charts and Charting in Excel | |||
calculate non linear equation lines using excel | Excel Discussion (Misc queries) | |||
equation problem | Excel Worksheet Functions |