[Excel] - IG distribution

Dason

Ambassador to the humans
#2
What do you mean by that? Do you want CDF values? Random deviates from the IG distribution? Density values?
 

Dason

Ambassador to the humans
#5
That seems to be for the normal distribution but the OP is asking about the Inverse Gaussian distribution.
 
#10
ok, in case anyone sees this thread, a simple way to find IG quantiles is through goal seek:

make one column of "wrong" x
set these xs in IG CDF function
and then change the wrong x cell to the wanted distribution, since F(x)=distribution.
 

Dason

Ambassador to the humans
#11
I don't understand what you're saying.

But I think you're just finding quantiles by plugging values into the CDF until you find a value that is close enough to what you want.