Apologies NORMINV uses differential calculus and mine is too rusty to give you a solution. If you have someone who is good at calculus and can break down the below into simple calculations (A x B, A^B, log(a) etc) then I'm sure we can build it. Normal inverse cumulative distribution function - MATLAB norminv - MathWorks United Kingdom The norminv function uses the inverse complementary error function erfcinv. The relationship between norminv and erfcinv is norminv ( p ) = − √ 2 erfcinv ( 2 p ) The inverse complementary error function erfcinv(x) is defined as erfcinv(erfc(x))=x, and the complementary error function erfc(x) is defined as erfc ( x ) = 1 − erf ( x ) = 2 √ π ∫ ∞ x e − t 2 d t .
... View more