No replies to this topic

[Generalray]

Hi i need help to find he right cataogue funcctions for he spreadsheet.
I want to use the function loginv, norminv and normdist from excel.

loginv: Returns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. If p = LOGNORMDIST(x,...) then LOGINV(p,...) = x.

norminv: Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

normdist: Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.

I hope some of you might know their equivalent or ways to replicate them
thanks ahead of time