excel - DAX Normal Distribution -
i looking function in dax acts norm.dist function in excel. have x value, mean, , standard deviation , looking find cumulative distribution (with accuracy of @ least 6 sigma).
i've searched through official list of dax statistical functions, not find function this. i'm looking economical way perform calculation. bell approximation best way go? iterated on table of 10,000 rows.
sign([x])*0.5*(1-(1/30)*(7*exp(-([x]^2)/2)+16*exp(-([x]^2)*(2-sqrt(2)))+(7+0.25*pi()*[x]^2)*exp(-([x]^2))))^0.5+0.5
given [x] normalized. max error = .0000304
error:
compared previous solution:
http://mathworld.wolfram.com/normaldistributionfunction.html (14)
Comments
Post a Comment