Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement in qlikview, for which one of the steps is to execute a weibull distribution, I know it does not exist in qlikview, but I would like to know if anyone knows if there is any way to apply the weibull distribution
Hi,
When you say execute a weibull distribution do you mean;
1) Draw a distribution given (static) shape and scale, or,
2) Best fit a weibull distribution to a set of data (i.e. calculate what the shape and scale should be somewhat dynamically)?
Cheers,
Chris.
Hi,
I think it looks more like the second option, it would be to replicate the formula in script like in Excel to a data set in a table:
WEIBULL (x, alpha, beta, cumulative) = Result
https://www.excelfunctions.net/excel-weibull-function.html
Hi,
So from here;
https://www.real-statistics.com/distribution-fitting/fitting-weibull-regression/
And a spreadsheet I found here;
On a toy application based on the spreadsheet I can generate the following with standard chart functions;
So it appears that the inputs to Weibull CDF/PDF can be calculated, from there these could possibly be fed into the long form of the CDF/PDF to plot the fitted distribution vs the actual (possibly using a variable to simplify?).
If this looks like it is going in the right direction happy to try to help further, a couple of caveats;
1) Examples I've seen overlaying a normal distribution have generally relied on CLASS calculated dimension to group the values & don't look great where the values are quite sparse (there may be a way round that though)
2) The stats here is we(ibu)ll out of my comfort zone ... so someone competent will need to sense check this is not a load of (wei)bull 😀
Cheers,
Chris.
Hi,
One thing that did occur after posting this is that there are ways of getting interoperability between R & QlikView, link below may be a starting point;
https://community.qlik.com/t5/QlikView-Integration/Usage-of-R-programming-with-Qlikview/td-p/1014803
This may or may not be simpler than the approach above in this case, but might open up more that you are interested in for the longer term.
Cheers,
Chris.