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)

Share

Share

Rate

5 (1)