Login     Register

        Contact Us     Search

XLeratorDB/statistics Documentation

SQL Server WEIBULL.INV function


WEIBULLINV

Updated: 31 July 2010

Use WEIBULLINV to calculate the inverse of the cumulative distribution function of the Weibull distribution.
 
The formula for the cumulative distribution function is:
 
 WEIBULLINV function for SQL Server
Syntax
SELECT [wctStatistics].[wct].[WEIBULLINV] (
  <@P, float,>
 ,<@Alpha, float,>
 ,<@Beta, float,>)
Arguments
@P
is the cumulative distribution function. @P is an expression of type float or of a type that implicitly converts to float
@Alpha
is the shape parameter of the distribution. @Alpha is an expression of type float or of a type that implicitly converts to float
@Beta
is the scale parameter of the distribution. @Beta is an expression of type float or of a type that implicitly converts to float
Return Types
float
Remarks
·         @P must be greater than zero and less than one (0 < @P < 1).
·         @Alpha must be greater than zero (0 < @Alpha).
·         @Beta must be greater than zero (0 < Beta).
Examples
Calculate the cumulative distribution function:
SELECT wct.WEIBULL(6, 1, 10, 'True')
 
This produces the following result
 
----------------------
0.451188363905974
 
(1 row(s) affected)

Calculate the inverse:
SELECT wct.WEIBULLINV(0.451188363905974,1, 10
This produces the following result
----------------------
6.00000000000001
 

(1 row(s) affected)



Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service