Hi, does anyone know how to generate a set of data according to a Weibull Distribution in Microsoft Excel?
Thanks =D
Let X ~ U(0,1) (X has a uniform distribution over [0,1) it is what the rand() function returns),
then W= lambda(-ln(X))^{1/k} has a Weibull distribution with parameters k and lambda.