NORMINV

,

SP to emulte Excel's NORMINV
--requires my NORMSINV script

ALTER    FUNCTION [dbo].norminv (@P float,@m float, @s float)

RETURNS float
as
begin
	declare @result float
	set @result = @m + @s*[dbo].NORMSINV(@p)
	return @result
end


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

Rate

5 (2)

Share

Share

Rate

5 (2)