Apply all four fit tests to the data, evaluating four possible distributions (normal, gamma, Weibull, and uniform).
SELECT * FROM DistnmatchReduce (
ON DistnmatchMultipleInput (
ON (SELECT RANK() OVER (PARTITION BY factory, product ORDER BY mttf)
AS rank, * FROM factory7 WHERE mttf IS NOT NULL) AS input
PARTITION BY ANY
ON (SELECT factory, product, COUNT(*) AS group_size FROM
factory7 WHERE mttf IS NOT NULL GROUP BY factory,
product) AS groupstats DIMENSION
ValueColumn ('mttf')
Tests ('KS', 'CvM', 'AD', 'CHISQ')
Distributions ('NORMAL:10000,150', 'GAMMA:1,10000',
'WEIBULL:100,10000','UNIFORMCONTINUOUS:9500,10500')
GroupingColumns ('factory', 'product')
MinGroupSize ('50')
NumCell ('10')
) PARTITION BY factory, product
);