Technical Article

loginv

,

SP to emulate Excel's Loginv
--Requires my Normsinv script

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO


ALTER  FUNCTION loginv (@P float,@mu float,@sig float)

RETURNS float

as
begin
declare @result float

return exp(@mu+@sig*dbo.normsinv(@p))

end

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

Rate

5 (1)

You rated this post out of 5. Change rating

Share

Share

Rate

5 (1)

You rated this post out of 5. Change rating